How do I combine multiple columns into just 1 column?

S

scosus

In my excel file, the address is split into 4 columns. I want to combine the
4 columns into 1.
 
R

rmellison

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
 
Top