Forum Discussion
Splitting alpha from numeric
I have a field which is essentially numeric with the possibility of a one character suffix. There can be 1, 2, or 3 numbers followed possibly by the alpha suffix ex: result num S...
Thank you so much for the very elegant solution.
And also for the quick response
And also for the quick response
Another alternative would be this...
To extract Numbers:
=IF(ISTEXT(A2),--LEFT(A2,LEN(A2)-1),A2)To extract Suffix character:
=IF(ISTEXT(A2),RIGHT(A2),"")