Separating Text From Numbers

  • Thread starter Thread starter Santi
  • Start date Start date
S

Santi

Hi,

Does anyone know the formula to separate text from numbers?
I tried applying the formula from an earlier post here (=LEFT(A1,LEN(A1)-B1)
=RIGHT(A1,LEN(A1)-B1+1) but it didn't work for me.
Did I miss something? Any help you can provide is greatly appreciated
 
You can use the LEFT, RIGHT, and MID formulas if the strings have some
consistancy in their makeup.......or, you can get the free add-in called ASAP
Utilities, available at www.asap-utilities.com which has a feature to delete
all alpha characters and/or to delete all numerical characters. You could
just copy your data over to two columns, and use them.

Vaya con Dios,
Chuck, CABGx3
 
If you post an example of the data you are working with, someone may
be able to help you.


HTH,
JP
 

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

Back
Top