Thiem:
I did the concatenate cell, however, when I deleted the old columns, I lost
everything. It appears that the function was still working between the
cells, therefore, when I deleted the old columns, the new columns were also
lost. Andy sent me a reply that helped me out.
Thanks anyway, your assistance was appreciated.
Sleepindogg
"Thiem" wrote:
Colum 1 Colum 2 = Colum 3
Colum 3 = Concatenate Cell (Colum 2) Cell (Colum2) Copy , then
Paste Value
If you want a space between data in C1 and C2
=Concatenate C1 (space) C2
cheers
--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=528148