Is there a tool that can help me separate the addresses in the attached into Name Address City State Zip in different columns? The way the system we are using put it in the current format but I am needing the data differently. I have tried to use text to columns, but either I am not doing it correctly, or it doesn't work. Any help and descriptions would be appreciated. Thanks!addresses.xlsx
The cells are merged and wrapped, I'm not sure there is a way to do what you want with merged/wrapped cells.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hi Amanda,
Enter formula in B1 and pull it to the right until you see blanks and then down
Formula:
Please Login or Register to view this content.
Last edited by AlKey; 12-22-2015 at 01:44 PM.
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
Wow, I was proven wrong. Thanks Alkey, I didn't know it could be done with merged/wrapped cells.
Thank you for your help AlKey. It worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks