Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 columns
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 columns
Hi. You can use concatenate(A1," ",B1)
"Neil" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 columns
=A1 & " " & B1
or the longer =CONCATENATE(A1," ",B1) Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 08:26:00 -0800, Neil wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 columns
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" wrote: =A1 & " " & B1 or the longer =CONCATENATE(A1," ",B1) Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 08:26:00 -0800, Neil wrote: 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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge 2 columns
After doing the merge using the formula, copy the cell(s) and EditPaste
SpecialValuesOKEsc. Gord On Mon, 28 Apr 2008 05:46:00 -0700, Angie wrote: 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" wrote: =A1 & " " & B1 or the longer =CONCATENATE(A1," ",B1) Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 08:26:00 -0800, Neil wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge columns | Excel Worksheet Functions | |||
merge columns e with f into e. | New Users to Excel | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
I want to merge two columns | New Users to Excel | |||
How to merge columns | Excel Worksheet Functions |