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...
As variant
=MID(E2,1, MIN(FIND({0,1,2,3,4,5,6,7,8,9},E2 & "0123456789")) +2)Perhaps as array formula (Ctrl+Shift+Enter) if not on 365 or 2021.