How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric?
On Apr 3, 1:41 pm, "ship" wrote:
Hi
How do I convert a string that contains letters and numbers
into a number using Excel2003 (or ms Access)
e.g. "£2,456.99 (including flights)"
== needs to be converted into the the numeric 2456.99
With thanks
ShipShipertonHenethe
I dont know what characters are going to be before or after the
number.
Basically I want to remove ALL characters apart from "0" to "9" and
"."
and then convert it into a numeric.
Any thoughts?
Ship
|