Merging Cells in Excel

calleyw

Right I have 4 columns and I need to merge the first three. Easy can do that.

But the problem I have is that I now want to take the data in the fifth column and move it to new a spreadsheet along with the fourth column. To create a mailing list.

Of course when I move the fifth column it then has no references to the first three columns so is just ##ref###

Is there anyway to merge the first three columns so they don't reference the first 3 columns.

Thanks in advance.


Yours


Calley

timnicebutdim_2

Not too sure if i get what you mean but have you tried "paste special" (first of all copy the data, then when you paste go to the edit menu> Paste special >Values) and it will paste the data as it appears (but not any formulas).

Alternatively if you just want to copy the spreadsheet and edit it into a new one go to the tab in the bottom left hand corner, right click, select 'Move or copy' and select 'create a copy'.

Hope that is what your after.

HtH

calleyw

timnicebutdim wrote: »

Not too sure if i get what you mean but have you tried "paste special" (first of all copy the data, then when you paste go to the edit menu> Paste special >Values) and it will paste the data as it appears (but not any formulas).

Alternatively if you just want to copy the spreadsheet and edit it into a new one go to the tab in the bottom left hand corner, right click, select 'Move or copy' and select 'create a copy'.

Hope that is what your after.

HtH

Doh, Thanks for that. You are a bright and shiny star.

I forgot about paste special. Can you tell that I am not a whizz with excel :rotfl:

Bit of an understatement that really.

Fan of Harry Enfield by any chance.

Yours


Calley

donny-gal

Instead of copying and pasting, you could open both Excel files or work sheets, and In the second, type = then navigate to the 5th column field in the first, and select and it will copy whatever is there into the new file or worksheet, then if you update the first, the second is automatically updated.

Hope it helps.
DG