How about this???
=LEFT(RIGHT(TRIM(A1),8),6)
Will only work, if the last three chars are " °C" and the number is in format 99.99
how do you think this will help you???
In that case, what you have devised is really good. It takes care of most of the stuff. Yours is really a full-proof formula though it is a bit slow.
BRAVO.
that's actually a pretty neat formula 
you've probably spotted that the text-to-columns method already takes 2 or 3 steps and is manual - whereas your formula is automatic, but potentially a speed-waster
how are you importing ? is it manually or part of a macro ? we could probably slot that formula into the import macro so it
1) imports
2) applies your formula
3) produces an ouput
4) tidies up after itself
if you want
Don’t have an account yet? Register yourself now and be a part of our community!
