Merge 2 columns

N

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?
 
A

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
 
G

Gord Dibben

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


Gord
 
Top