Forum Discussion
Trim Function
All, Is there a way to use TRIM/LEFT/RIGHT/LEN with an Excel textstring to remove the Nth character after the Nth occurrence of a numeric value? As an example, I would like to have a function...
berg8630 Not sure what H2O had in mind with his/her/its AI reply but perhaps the picture below demonstrates what you asked for.
The formula in F2 is like this:
=MID(E2,1,2+MATCH(TRUE,(ISNUMBER(--(MID(E2,SEQUENCE(LEN(E2)),1)))),0))Note that it requires Excle365 or 2021 due to the use of the SEQUENCE function.