View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default How to combine data from two columns into one column?

Hi

Try
=A1&B1

If you ever need a space in between, then
=A1&" "&B1

--
Regards

Roger Govier


"dcnguyen" wrote
in message ...

Beginner question: Just want to know if there's a quick and easy way
to
take the data from one column and append it to another...so, two cells
containing "ABC" and "DEF" respectively would end up as one cell,
"ABCDEF"


--
dcnguyen
------------------------------------------------------------------------
dcnguyen's Profile:
http://www.excelforum.com/member.php...o&userid=30251
View this thread:
http://www.excelforum.com/showthread...hreadid=499220