Extract States from a String

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

FAQ

Thread Tools

Display Modes

04-23-2018, 02:14 PM

soldat452002 soldat452002 is offline

Windows 7 64bit Extract States from a String

Office 2010 64bit

Novice

Join Date: Apr 2018

Location: Los Angeles

Posts: 6

Extract States from a String

Hello

I have a database that generates the following string based on a web form selection.

I need to extract the state names only from these strings.

How can I achieve that in Excel? I tried everything

[{"licenseexpdate":"","licensenumber":"ysdksnjdkl", "state":"Pennsylvania"},{"licenseexpdate":"08/12/2020","licensenumber":"lic1235","state":"Florida"} ,{"licenseexpdate":"","licensenumber":"gsdgfsef"," state":"South carolina"}]

« Previous Thread | Next Thread »

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 07:43 PM.