Thread: Extract States from a String
View Single Post
 
Old 04-24-2018, 06:04 AM
soldat452002 soldat452002 is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Apr 2018
Location: Los Angeles
Posts: 6
soldat452002 is on a distinguished road
Default
Quote:
Originally Posted by NoSparks View Post
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.
Reply With Quote