Separating Text From Numbers

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
 
C

CLR

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
 
J

JP

If you post an example of the data you are working with, someone may
be able to help you.


HTH,
JP
 
Top