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

Question

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.

ac3mark · Answer

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!

mcat79 · Answer

I don't see anywhere to attach an excel document

ac3mark · Answer

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

ac3mark · Answer

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

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

4 responses

Similar discussions

Subscribe To Our Newsletter!