Thread: How do I combine multiple columns into just 1 column?
View Single Post
  #2   Report Post  
rmellison
 
Posts: n/a
Default How do I combine multiple columns into just 1 column?
In a fifth column, use the concanenate function or amphisand to combine the
information. Then drag down to copy for each row.

=CONCATENATE(A1,B1,C1,D1)
or
=A1&B1&C1&D1

HTH


"scosus" wrote:

In my excel file, the address is split into 4 columns. I want to combine the
4 columns into 1.
Reply With QuoteReply With Quote