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?

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?

=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

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

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