Extracting Data with in Brackets [ ...... ]

[lamalatrin]

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

 

[Max]

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