Sorting Data into columns without replacing the columns with data

[Guest]

Hello everyone,

How do you sort data into columns without replacing other columns with data?
Example:
Column A: Column B: Column C:
Cost Ctr Asset Doc. No. Amount Cum. Amt
88888 8888 888 88888 88888

I've tried using "text to columns" but end-up replacing column b n c
respectively.
Is there a way to use "text to columns" which automatically inserts the
column without replacing the columns in the first place? it's pretty tedious
if manually inserting the no. of columns needed when you have alot of data.
Hope anyone can assist me in this matter.
thank you.

 

[Guest]

The technique I use is to:

1. tell Text to Columns to put the resulting columns "far away" from the
rest of the worksheet (way to the right of the original columns)

2. select the new columns and do a mouse-over the area edge until I get the
"four-headed arrow"

3. right-click and drag the new columns over with the option:

Shift right and Move

B.T.W:

You can re-position any column using the technique.

 

[David Biddulph]

Thanks for that tip. I hadn't spotted the "Destination" field in the
wizard.