Thread: merge text from 2 columns into 1 then delete the old 2 columns
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thiem
 
Posts: n/a
Default merge text from 2 columns into 1 then delete the old 2 columns

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

Reply With QuoteReply With Quote