How do I extract specific data from a cell in excel?

Closed
mcat79 Posts 2 Registration date Tuesday July 12, 2016 Status Member Last seen July 12, 2016 - Jul 12, 2016 at 05:58 PM
 Blocked Profile - Jul 12, 2016 at 07:04 PM
Hello, what function would I use to extract just the city name from the cells below?...thanks!

6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A.
7899 E 88TH ST ,, ,INDIANAPOLIS, IN 462561233, U.S.A.
481 Airport Industrial Dr # 101 ,, ,Southaven, MS 386715880, U.S.A.
4320 Executive Dr Ste 400 ,, ,Southaven, MS 386728116, U.S.A.
151 Industrial Rd ,, ,Ashland, MS 386036720, U.S.A.
1 Ring Dr ,, ,Saint Joseph, MO 645031511, U.S.A.
1301 MARINA VILLAGE PKWY ,STE 200, ,ALAMEDA, CA 945011082, U.S.A.

4 responses

Blocked Profile
Jul 12, 2016 at 06:18 PM
Well, you have no cells! That is a poor example. Set it in an excel sheet and then we can possible assist you! Please post back!
0
Blocked Profile
Jul 12, 2016 at 06:20 PM
You do know that you can IMPORT a comma delimited file into excel, right?
0
mcat79 Posts 2 Registration date Tuesday July 12, 2016 Status Member Last seen July 12, 2016
Jul 12, 2016 at 06:43 PM
I don't see anywhere to attach an excel document
0
Blocked Profile
Jul 12, 2016 at 06:58 PM
YOu take a screen shot, use snipping tool. Save it. then upload the picture! as in:


So, this is an excel file, being uploaded from text:


Give you this:



It's kind of fun to do the impossible! -Walter Elias Disney
0
Blocked Profile
Jul 12, 2016 at 07:04 PM
the complete process for taking your data, and making the above sheet, took me, 5 minutes. I copied your post, and pasted it into a notepad, then saved it where i could remember where it was!

Then I opened Excel, and selected Data> Get External data> text file. Then browsed to where I saved the text file from step 3.

Viola!

It's kind of fun to do the impossible! -Walter Elias Disney
0