Hi
Would like an array formula to strip numbers out of a string. I have seen one version using, help appreciated. I think there are some variations of =MID() where the contents of a cell are split into an array (1 character each) then analysed for digits.
ABC01234567/01
I would ideally like 2 formulas :
1. Split all numbers = 0123456701
2. Split before a given character = before *-/ = 01234567
3. Split before a pattern = before 7/ = 0123456
Any thoughts. Array with MID sounds like a good option?
Would like an array formula to strip numbers out of a string. I have seen one version using, help appreciated. I think there are some variations of =MID() where the contents of a cell are split into an array (1 character each) then analysed for digits.
ABC01234567/01
I would ideally like 2 formulas :
1. Split all numbers = 0123456701
2. Split before a given character = before *-/ = 01234567
3. Split before a pattern = before 7/ = 0123456
Any thoughts. Array with MID sounds like a good option?