Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data with in Brackets [ ...... ]
I only want the data that is contained in the brackets. I only need
the address and not the directions to the places. Any and all hepl is appreciated. Depart 786 BROOKHURST BOULEVARD [786 BROOKHURST BOULEVARD, LATHROP, CA 95330] on Brookhurst Blvd (East) 76 yds Turn RIGHT (South) onto Late Harvest Pl 0.1 mi Road name changes to Grapevine Pl 43 yds Turn RIGHT (South) onto Winter Wheat Ln 54 yds At 17950 WINTER WHEAT LANE [17950 WINTER WHEAT LANE, LATHROP, CA 95330], return North on Winter Wheat Ln 54 yds Turn RIGHT (East) onto Grapevine Pl 142 yds Turn RIGHT (South) onto Rusty Plow Ln 43 yds At 17975 RUSTY PLOW LN [17975 RUSTY PLOW LN, LATHROP, CA 95330], return North on Rusty Plow Ln 43 yds Turn RIGHT (East) onto Grapevine Pl 120 yds Turn LEFT (North) onto Golden Spike Trail 87 yds At 17116 GOLDEN SPIKE TRL [17116 GOLDEN SPIKE TRL, LATHROP, CA 95330], turn RIGHT (East) onto Cold Springs St, then immediately turn RIGHT (South) onto Daffodil Hill Way 0.1 mi Road name changes to Apple Grove Ave 43 yds At 406 APPLE GROVE AVENUE [406 APPLE GROVE AVENUE, LATHROP, CA 95330], stay on Apple Grove Ave (East) 43 yds Turn LEFT (North) onto McKee Blvd 43 yds At 17947 MCKEE BOULEVARD [17947 MCKEE BOULEVARD, LATHROP, CA 95330], stay on McKee Blvd (North) 0.2 mi Turn RIGHT (East) onto American Farms Ave 0.1 mi Turn RIGHT (South) onto Garden Glade St 98 yds At 232 LAZY RIDGE AVENUE [232 LAZY RIDGE AVENUE, LATHROP, CA 95330], turn RIGHT (West) onto Lazy Ridge Ave 0.1 mi Turn RIGHT (North) onto Water Mill St, then immediately turn LEFT (West) onto American Farms Ave 142 yds Turn RIGHT (North) onto McKee Blvd, then immediately turn RIGHT (East) onto Crescent Moon Dr 0.2 mi At 17463 FERNDALE ST [17463 FERNDALE ST, LATHROP, CA 95330], return West on Crescent Moon Dr 65 yds At 17481 STONE CELLAR WAY [17481 STONE CELLAR WAY, LATHROP, CA 95330], turn RIGHT (North) onto Stone Cellar Way 76 yds |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data with in Brackets [ ...... ]
Assuming data in A2 down, with the single pair of left/right brackets as the
keypoints In B2: =MID(A2,SEARCH("[",A2)+1,SEARCH("]",A2)-SEARCH("[",A2)-1) Copy down -- Max Singapore ---- "lamalatrin" wrote in message ... I only want the data that is contained in the brackets. I only need the address and not the directions to the places. Any and all hepl is appreciated. Depart 786 BROOKHURST BOULEVARD [786 BROOKHURST BOULEVARD, LATHROP, CA 95330] on Brookhurst Blvd (East) 76 yds Turn RIGHT (South) onto Late Harvest Pl 0.1 mi Road name changes to Grapevine Pl 43 yds Turn RIGHT (South) onto Winter Wheat Ln 54 yds At 17950 WINTER WHEAT LANE [17950 WINTER WHEAT LANE, LATHROP, CA 95330], return North on Winter Wheat Ln 54 yds Turn RIGHT (East) onto Grapevine Pl 142 yds Turn RIGHT (South) onto Rusty Plow Ln 43 yds At 17975 RUSTY PLOW LN [17975 RUSTY PLOW LN, LATHROP, CA 95330], return North on Rusty Plow Ln 43 yds Turn RIGHT (East) onto Grapevine Pl 120 yds Turn LEFT (North) onto Golden Spike Trail 87 yds At 17116 GOLDEN SPIKE TRL [17116 GOLDEN SPIKE TRL, LATHROP, CA 95330], turn RIGHT (East) onto Cold Springs St, then immediately turn RIGHT (South) onto Daffodil Hill Way 0.1 mi Road name changes to Apple Grove Ave 43 yds At 406 APPLE GROVE AVENUE [406 APPLE GROVE AVENUE, LATHROP, CA 95330], stay on Apple Grove Ave (East) 43 yds Turn LEFT (North) onto McKee Blvd 43 yds At 17947 MCKEE BOULEVARD [17947 MCKEE BOULEVARD, LATHROP, CA 95330], stay on McKee Blvd (North) 0.2 mi Turn RIGHT (East) onto American Farms Ave 0.1 mi Turn RIGHT (South) onto Garden Glade St 98 yds At 232 LAZY RIDGE AVENUE [232 LAZY RIDGE AVENUE, LATHROP, CA 95330], turn RIGHT (West) onto Lazy Ridge Ave 0.1 mi Turn RIGHT (North) onto Water Mill St, then immediately turn LEFT (West) onto American Farms Ave 142 yds Turn RIGHT (North) onto McKee Blvd, then immediately turn RIGHT (East) onto Crescent Moon Dr 0.2 mi At 17463 FERNDALE ST [17463 FERNDALE ST, LATHROP, CA 95330], return West on Crescent Moon Dr 65 yds At 17481 STONE CELLAR WAY [17481 STONE CELLAR WAY, LATHROP, CA 95330], turn RIGHT (North) onto Stone Cellar Way 76 yds |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphical co-ordinates format data label (with brackets) for chart | Charts and Charting in Excel | |||
extracting data from one sheet based on data in another - VLookup? | Excel Worksheet Functions | |||
Need help with pulling out data between brackets | Excel Worksheet Functions | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Extracting a value from between brackets | Excel Discussion (Misc queries) |