Extract States from a String

NoSparks · #1 04-23-2018, 04:53 PM

Sorry, I must have missed what was to be done with the results so just displayed them as they were being extracted in a message box in order to see the results.

You need to replace the MsgBox line with the cell address(s) you're wanting the result(s) to go in to.
For a more accurate/specific answer more information is required.

What's the sheet name? What column? All in one cell or ???

soldat452002 · #2 04-24-2018, 06:04 AM

Quote:

Originally Posted by NoSparks

Sorry, I must have missed what was to be done with the results so just displayed them as they were being extracted in a message box in order to see the results.

You need to replace the MsgBox line with the cell address(s) you're wanting the result(s) to go in to.
For a more accurate/specific answer more information is required.
What's the sheet name? What column? All in one cell or ???

I want to insert the results in a separate column called states next to the string.sheet name is extract.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract a string from a paragraph	kirkm	Word VBA	7	09-11-2016 06:13 PM
How to extract only numbers from a STRING?	Learner7	Excel	3	07-02-2013 06:25 AM
Extract Numbers from Alphanumeric String	OTPM	Excel	6	05-13-2011 12:52 AM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM
Extract from String using Wildcard	whousedmy	Word	0	05-21-2009 01:35 AM