Merge 2 columns

[Neil]

Hi i would like to merge 2 or 3 columns i have searched and founds this

=CONCATENATE(A1,B1)

This works put puts them in 1 column together i would like to be able to
havea gap betweeen them . So not 2woodbury road but 2 Woodbury Road.

Does anyone have any suggestions?

 

[Petros]

Hi. You can use concatenate(A1," ",B1)

 

[Gord Dibben]

=A1 & " " & B1

or the longer =CONCATENATE(A1," ",B1)


Gord Dibben MS Excel MVP

 

[Angie]

Both of these work find for me as well. How can I get this to work without
having a formula in the cell. I need to name and reference the cells, for a
list, after merging the columns.

-Angie

 

[Gord Dibben]

After doing the merge using the formula, copy the cell(s) and Edit>Paste
Special>Values>OK>Esc.


Gord