Multi line Text-to-column - A CHALLENGE FOR YOU!
January 24, 2008 3:01 PM Subscribe
How to "text to column" a cell with multiple lines in Excel?
posted by keasby to computers & internet (7 answers total) 2 users marked this as a favorite
I need to extract a cell that contains multiple lines (name, address, etc) into a column for each line. IE.
212 Fifth Avenue
NY NY 10001
There are no useful delimiters like ; or anything.
I tried using "other" in the delimiter option and hitting alt-enter but it doesn't recognize. Further, it doesn't even pick up the second line of data in the display field.
Someone must have a macro out there for this! Help!