Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I merge two columns without losing data?
If I want to split a column in two, I know I can use the Text to Column
feature. How can I go from two columns to one without losing data in the merge? |
#2
|
|||
|
|||
One way
=CONCATENATE(A1,B1) Ian --- "Caseybay" wrote in message ... If I want to split a column in two, I know I can use the Text to Column feature. How can I go from two columns to one without losing data in the merge? |
#3
|
|||
|
|||
=a1&b1
or =a1&" "&b1 (use a helper column of formulas.) Caseybay wrote: If I want to split a column in two, I know I can use the Text to Column feature. How can I go from two columns to one without losing data in the merge? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge two columns without losing data?
this worked fine - however, if i delete the original columns i get an error
that the reference data is gone.....and i only want to work with the new column i tried copying and pasting to new worksheet but that didn't work either. what to do? "Dave Peterson" wrote: =a1&b1 or =a1&" "&b1 (use a helper column of formulas.) Caseybay wrote: If I want to split a column in two, I know I can use the Text to Column feature. How can I go from two columns to one without losing data in the merge? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge two columns without losing data?
Urbie
CopyPaste SpecialValuesOKEsc. Then delete the original columns. Gord Dibben MS Excel MVP On Fri, 13 Jan 2006 12:46:03 -0800, "Urbie" wrote: this worked fine - however, if i delete the original columns i get an error that the reference data is gone.....and i only want to work with the new column i tried copying and pasting to new worksheet but that didn't work either. what to do? "Dave Peterson" wrote: =a1&b1 or =a1&" "&b1 (use a helper column of formulas.) Caseybay wrote: If I want to split a column in two, I know I can use the Text to Column feature. How can I go from two columns to one without losing data in the merge? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
Macro to Synchronize data frm svrl workbooks & columns to 1 workbo | Excel Discussion (Misc queries) | |||
Merging columns of data | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
merge data problems | Excel Worksheet Functions |