CONVERT TEXT 2 NUMBERS
Hi,
With this in A1
q2q
=Mid(a1,2,1)
extracts the 2 and you can still do arithmatic on it
If you want it to right justify like a number multiply it by 1
=Mid(a1,2,1)*1
Mike
"FARAZ QURESHI" wrote:
I have used quite some scheme of formulas like left(), right() to extract the
"numbers" from a list of codes but they turn out to be in text form. Any idea
how to use some sort of =Text() like function so as to convert the extracted
figures to numbers?
--
Best Regards,
FARAZ A. QURESHI
|