Merge 2 cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pwallis@bigpond.net.au - 12 Feb 2008 10:29 GMT

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

Reply to this Message

Pete_UK - 12 Feb 2008 10:34 GMT

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...@bigpond.net.au wrote:

> Hi,
> I have formated 2 Text columns to General and tried every which way to
[quoted text clipped - 4 lines]
> works just fine.
> Any ideas before I go and manually edit 3600 lines if data

Reply to this Message

pwallis@bigpond.net.au - 12 Feb 2008 10:43 GMT

Nope, was formated as General. So I copied columns A and B to a new
sheet and the merged them. Worked just dandy. Copied the result back
with edit-paste special and everyone is happy. I might just copy all
the data to a new sheet. sounds like there is a bug in the
worksheet???
Cheers
Pete

> 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
[quoted text clipped - 15 lines]
> > works just fine.
> > Any ideas before I go and manually edit 3600 lines if data

Reply to this Message

Pete_UK - 12 Feb 2008 10:52 GMT

I'm glad you found a solution - thanks for feeding back.

Pete

On Feb 12, 10:43 am, pwal...@bigpond.net.au wrote:

> Nope, was formated as General. So I copied columns A and B to a new
> sheet and the merged them. Worked just dandy. Copied the result back
[quoted text clipped - 25 lines]
>
> - Show quoted text -

Reply to this Message