Hello,

After using a web query from Mapquest, I found that the Distance (in
miles) between the two locations is imported along with the text.
The cell reads:

"Total Est. Time: 1 hour, 57 minutes Total Est. Distance: 100.38
miles"

Can someone please explain how I can isolate the number of miles
( 100.38 ) into its own cell using VBA?

Also, another huge web query displays the names of NJ schools in this
format:

"» Atlantic City H.S. (01-0110-010)" (Yes the "»" is always included
at the beginning). Anyway to isolate the text here to just yield
( Atlantic City H.S.)?

Any help would be greatly appreciated.

Thanks,
Jon