How do I merge two columns without losing data?

C

Caseybay

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?
 
U

Urbie

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?
 
G

Gord Dibben

Urbie

Copy>Paste Special>Values>OK>Esc.

Then delete the original columns.


Gord Dibben MS Excel MVP
 
Top