Thread: How do I separate the alpha prefix from a text (abc123 or a1234)?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kskaug1
 
Posts: n/a
Default How do I separate the alpha prefix from a text (abc123 or a1234)?
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!
Reply With QuoteReply With Quote