I have a worksheet with cells containing multiple phrases, each separated by line breaks (Alt+Enter).
I need a search, function or formula to extract or break down those cells with EACH phrase into it's own, separate cell. i.e., I need the cell with 5 phrases split out into 5 cells.
How would I target the line breaks and snag the entire string to the LEFT of each one and have it deliver me each string in it's own cell?
Thanks!
If the cells contain line breaks (probably entered by ALT+ENTER),
try this:
• Select the single-column range of cells to be parsed at each line break
• Data.Text-to-Columns
...Check: Delimited....Click: Next
...Check: Other....put CTRL+j in the character box
...Click: Finish
Is that something you can work with?
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks