Posted to microsoft.public.excel.misc

Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline

external usenet poster

Posts: 1,045

Extracting specific info from cells

On Fri, 15 Jun 2012 15:56:54 +0000, johnhaskell wrote:

Ok for example, a string might say 6 CALLE A 10-47 COLONIA LODELPUENTES
ZONA 11 DE MIXCO
(its actually zona, not zone) haha

My previous alteration was incorrect as zone is used twice:

=IF(ISERR(SEARCH("zona ",A1)),"",
MAX(IFERROR(--MID(A1,
SEARCH("zona ",A1)+5,ROW(INDIRECT("1:10"))),0)))

and be sure to enter this as an **array formula** as I described in my original response.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
extracting specific info from text cell.	Chipgiii	Excel Programming	3	January 26th 10 06:44 PM
extract specific info from cells in a column	Herman	New Users to Excel	1	October 27th 05 03:01 AM
Extracting specific data from cells	AndyUK[_2_]	Excel Programming	0	November 11th 04 02:53 PM
Extracting specific data from cells	AndyUK	Excel Programming	1	November 11th 04 02:32 PM
Extracting Specific Information in Cells	JHawaii	Excel Programming	0	September 11th 03 05:43 PM

All times are GMT +1. The time now is 03:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us