Extract States from a String

		Microsoft Office Forums > Microsoft Excel > Excel
Extract States from a String

04-24-2018, 08:16 AM

NoSparks

Windows 7 64bit Extract States from a String

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Sub in attached is commented line by line, hopefully makes sense.
Comment out or remove the lines of the result you don't want.

Hope that helps.

Attached Files

soldat452002.xlsm (18.8 KB, 22 views)

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:06 AM.