Re: Merge 2 cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Change the format of cell C1 to General using Format | Cells | Number
tab - it is probably set to Text at present. Then double-click on the
cell as if to edit it and press <enter> in order to bring about the
change of format. Then you can copy the formula down.

Hope this helps.

Pete

On Feb 12, 10:29 am, pwal...@xxxxxxxxxxxxxx wrote:
Hi,
I have formated 2 Text columns to General and tried every which way to
merge the cells into one. A1 would be "Style" B1 would be "335B".
Cell C1 is formated as general. The formula in cell C1 is =A2&" "&B2.
No matter what I do it only displays the formula.
Tried the same exercise in a new sheet with the same value and it
works just fine.
Any ideas before I go and manually edit 3600 lines if data

.

Relevant Pages

  • Easily resolved
    ... 'Text' formatted cells displaying numbers in scientific format ... I use Excel to view statement information downloaded from my bank in CSV ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ...
    (microsoft.public.excel)
  • Re: Actual solution
    ... Then format the cells as text ... some cells still display the numeric string in scientific ... Selecting the cell shows that it's already correctly formatted. ... Microsoft Excel MVP ...
    (microsoft.public.excel)
  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)
  • Excel 07 - text displays as pound signs
    ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ... any given cell will suddenly appear as all pound signs. ... changed the format to a date. ...
    (microsoft.public.excel.newusers)
  • Re: Entering times in 24 hour format
    ... GoTo endtime ... If I format the cell to accept "hh:mm" times, ... 0800, or 800 in the cell, when they tab out, it will convert to 08:00. ...
    (microsoft.public.excel.misc)