I have used this formula =--LEFT(V2,FIND(" ",V2)) to find the first number in the string but I need to find the second number, I have used this =MID(V2,12,3) but I cant get it to display as a number, I have tried --MID(V2,12,3) but I get a #value error. This is my string of text 37 families68 Children. I'm sure its quite simple really!!!
You could tryorFormula:
Please Login or Register to view this content.but you would be better uploading a sample workbook with more examples (and expected results).Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks