How do I separate the alpha prefix from a text (abc123 or a1234)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
ASAP Utilities, a free Add-in available at www.asap-utilities.com has
features that will delete all alpha characters and/or all numeric
characters..........

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup and Replace with value 4
separating alpha numeric vlue 23
Extracting elements of a string cell 11
Matching and calculating 2 worksheets 5
How to 'split' data from 1 column into 2?? 6
Remove text from cell 10
Removing an alpha characture from a column of numbers 5
Single quotation mark prefix 5

Back
Top