|Subject:||Remove space and trailing text from number|
|Posted by:||gossamer (firstname.lastname@example.org)|
|Date:||Wed, 1 Oct 2003|
Using xl xp pro.
Receive text file wish to convert to xl
Some data comes in like this:
Would like to trim " oz" w/o quotes
So all I'm left with is 12
Here's my formula:
However other data comes in this format:
How could I re-work my formula to take care of either condition
Remaining value beginning from left of string could be any number of digits
If col a contains text I receive #value! error
I take care of this with
But it would be more elegant if I could incorp all into 1 formula.