Hello,
I need to separate numbers from names. However, there are no spaces between the name and numbers. The numbers are with or without dashes.
Please see attached spreadsheet.
Column A is the original output
Columns B & C is my desired results
Thank you in advance!
Carol
In B2 copied down
Formula:
Please Login or Register to view this content.
In C2 copied down
Does that work for you?Formula:Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you ChemistB.
I trimmed the original cell before implementing the two formulas. I was able to get the first formula to work on my worksheet, but not the second one.
To the second formula
Formula:Please Login or Register to view this content.
Jose,
This formula basically copied Cell A2
No, Carol. It is not the same at all.
For B2 use
Formula:Please Login or Register to view this content.
as ChemistB said
For C2 use
Formula:Please Login or Register to view this content.
Drag down
See the file
Last edited by José Augusto; 10-07-2020 at 11:58 AM. Reason: Add the file
Jose,
Thank you for the clarification. This did work!
Have a great evening!
Carol
You are welcome,
I wonder why my second formula didn't work.
For me it worked well, but ... I don't know eitherOriginally Posted by ChemistB
I wonder why my second formula didn't work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks