Thread: How do I combine multiple columns into just 1 column?

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

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.