Why are you searching for a decimal? It seems that all you need is everything to the left of the ampersand. If that is the case, this should work:
I have an Excel file that quiries Google for driving distance (someone helped me with this.) It returns the correct miles but has some 'extra' characters.
31.1&nb or 886&nbs
So the answer always has &nbs after the mileage. I tried the following function which works when there is a decimal but fails when there is not.
Can this be done with a function or must it be VB script? Which is fine if it is.
If you wish to continue using this free service.
Please be considerate of others who use the forum for searching. Your current Thread Title (which I will change) is non-reflective of your immediate problem.
In future, please take 1 minute of your time to read the text on the New Thread page.
Please take just 3 mins of your time to read: How To Get Your Question Answered...FAST! AND Anatomy Of A Good Thread Title
REMEMBER: Your thread title should NEVER be what you THINK is your answer. 9 times out 10 it will wrong and prevent someone from finding a solution to a simliar issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)