MrExcel Publishing
Your One Stop for Excel Tips & Solutions

String manipulation in imported data


Posted by Andy Smithers on May 21, 2001 8:16 AM

I have what is probably a simple problem (to you guys anyway!).
I have a column consisting of data like:

C1 C2 C3-C17 C21
or
XP3 XP27-XP67 XP99

etc.

I need this converted to:

C1 C2 C3 C4 C5 C6 C7 C8 .....
or
XP3 XP27 XP28 XP29 XP 30 .....

Any help greatly appreciated.

Andy.


Posted by Barrie Davidson on May 22, 2001 10:03 AM

If I understand your problem, you have data in one column that you want to break up into several columns. If that is correct, have you tried (from the menu bar) Data|TexttoColumns ?

Barrie