LinkBack URL
About LinkBacks
Does anyone know of a simple formula to extract the nth word of a cell?
Does anyone know of a simple formula to extract the nth word of a cell?
Try this, with text in A1 and n in A2
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
Try this
With text string in cell A1
Enter formula in B1
Formula:Please Login or Register to view this content.
In this case formula will return 3rd word in the string
By changing 300 number to 100 will return 1st word, If you change to 400 it will return 4th word
v A B 1 This is just a test just
Last edited by AlKey; 03-21-2019 at 03:23 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
Please Login or Register to view this content.
You could insert the macro into your “Personal.xlsb” macro book but that is stored on your computer so will not follow you if you are on a different computer. It also requires you enter the name of the workbook like this
Formula:Please Login or Register to view this content.
each time.
Alternately, you can create a template with that code in it and load that template each time you plan on designing a workbook with a need for that.
I think you’d be better off using the formula approach.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks