Merge 2 columns

  • Thread starter Thread starter Neil
  • Start date Start date
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?
 
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
 
After doing the merge using the formula, copy the cell(s) and Edit>Paste
Special>Values>OK>Esc.


Gord
 
Back
Top