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

[Closed]
Report
Posts
2
Registration date
Tuesday July 12, 2016
Status
Member
Last seen
July 12, 2016
-
 Blocked Profile -
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 replies


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!
Blocked Profile
You do know that you can IMPORT a comma delimited file into excel, right?
Posts
2
Registration date
Tuesday July 12, 2016
Status
Member
Last seen
July 12, 2016

I don't see anywhere to attach an excel document

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

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