Forum Discussion
NorskGrandpa
Apr 04, 2021Copper Contributor
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...
Riny_van_Eekelen
Apr 04, 2021Platinum Contributor
NorskGrandpa Please see the attached workbook for two working examples. One with regular formulae and one using Power Query.
Detlef_Lewin
Apr 04, 2021Silver Contributor
Alternative formulas:
=IF(ISNUMBER(--RIGHT(A2)),A2,--LEFT(A2,LEN(A2)-1))
=SUBSTITUTE(A2,C2,"")