Remove text from cell
Hi Bob,
I take it back about needing a macro if variable :-o
Can you explain the elements in this please? With the 9.9... and {} etc I'm
lost.
Cheers
Giz
"Bob Phillips" wrote:
Regardless of position
=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"
0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Scoops" wrote in message
oups.com...
Hi Thomas
If your data is fixed at aaannn then you can use:
=RIGHT(A1,3)
Regards
Steve
|