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
