Hi Duke

Thanks for the quick reply....

I just have one more question.

I need to send my data to a company but with only certain columns
showing. Hiding them is not possible so I have to actually delete the
columns that are not needed.

So, after I have merged the 2 cells together as you showed me, I need
to copy the data from the merged cell to another cell so that it
doesn't show #REF when I delete the original 2 cells.

I hope I'm explaining myself OK! Here goes another way.....

Once I have merged A1+B1 into C1 as you showed me, I only need to keep
cell C1 (otherwise this will confuse the printer's software). But if I
remove cells A1 + B1, cell C1 cannot function because I have
effectively removed the data that the formula in C1 is looking at.
Therefore, do I need to somehow copy the data in C1 (rather than the
formula) to another cell so that I can remove A1 and B1 (and then C1)
without causing a problem?

Phew!

Thanks

Jon
:)


--
fuzzyjon
------------------------------------------------------------------------
fuzzyjon's Profile: http://www.excelforum.com/member.php...o&userid=34378
View this thread: http://www.excelforum.com/showthread...hreadid=541570