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