MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Parsing Column Text into New Columns


Posted by Don Moen on November 16, 2000 12:22 PM

I need to seperate text in a column into new columns based on a field seperator. The example cell contents below use the % seperator. How can I do this?

smtp:donm@go.com%smtp:donaldm@old.go.com%smtp:dm@go.com%smtp:dem@go.com%smtp:Don.Moen@go.com


Posted by Tim Francis-Wright on November 16, 2000 1:22 PM


smtp:Don.Moen@go.com

Use the Text To Columns feature in the Data menu.
Choose Delimited in Step 1, then put the % sign
in the Other box in Step 2. Excel will then
put each delimited entry into its own cell.

HTH!

Posted by Don Moen on November 16, 2000 2:19 PM


Wow! That worked great. Thanks a bunch!

Don