K
kskaug1
I cannot use Text-to-column as the alpha spacing is inconsistent. Is there a
formula that I can use to pull the alpha (or numberic) prefix from a text in
Excel.
Ex:
abc123
ab1234
abcd12345
123abc
12abcde
Thanks!
formula that I can use to pull the alpha (or numberic) prefix from a text in
Excel.
Ex:
abc123
ab1234
abcd12345
123abc
12abcde
Thanks!