Hi guys!
I have a question about extract numbers/words from a string in excel not use VBA.
In A1: 1234ABCD
In A2: 123DEF
In A3: 1234FGH
In A4: 123HKLM
and
In B1: I want get 123 from A1
In C1: I want get ABCD from A1
so on...
Thanks!