Hi Everyone,
Do you know how to make a list in one column appear separated in new columns? The cell contains locations, separated by returns. Is there a way to make new cells for each of these locations? I've posted a screenshot of what I hope to create. Is there a formula to do this? Thanks.
Enter formula in B1 and copy across
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Highlight your column of data, making sure the columns to its right are empty.
On the Data ribbon, Select Text to Columns.
Select the Delimited option, and then check the Other option.
In the delimiter type box press CTRL+J and click on Finish.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks very much. I can see how this should work but I have a mac. Any idea if there is a different shortcut to try?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks