need to make 3 fields into 1 field

G

Georgia

I have an mail list that has been created with 3 address fields. These
fields need to be consolidated into 1 field. Can this be done.

Thanks
 
G

Gord Dibben

Georgia

Most programs that use Adresses like them in separate fields but if you need
in one field......

=A1 & " " & B1 & " " & C1

The " " are to insert spaces.

Gord Dibben Excel MVP
 
Top