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?

One way

=CONCATENATE(A1,B1)

Ian
---

"Caseybay" <[email protected]> wrote in message
news:[email protected]...
> 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

Copy>Paste Special>Values>OK>Esc.

Then delete the original columns.


Gord Dibben MS Excel MVP

On Fri, 13 Jan 2006 12:46:03 -0800, "Urbie" <[email protected]>
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
>>