How do I pull just the numeric characters in a cell?

[punter]

Hi,

I have some cells that I want to pull just the numeric value so I can
do a Vlookup off the number. Example: 12345678DM. In the cell next
to it I would like to pull just the number while leaving the DM off. I
can't always promise that the amount of numbers will be 8 so I can't
just do a =left(A1,8) or something. Any ideas?

Thanks as always,

Eddie

 

[Ragdyer]

Try this:

=--LEFT(A1,LEN(A1)-2)

 

[ImpulseBlue]

you can still do the left if you know that there will always be 2
letters at the end:
=LEFT(F5,LEN(F5)-2)

Hope that helps

 

[oldchippy]

Hi,

I have some cells that I want to pull just the numeric value so I can
do a Vlookup off the number. Example: 12345678DM. In the cell next
to it I would like to pull just the number while leaving the DM off. I
can't always promise that the amount of numbers will be 8 so I can't
just do a =left(A1,8) or something. Any ideas?

Thanks as always,

Eddie

Hi Eddie,

Try something like this,

=LEFT(A1,FIND("DM",A1)-1)*1

oldchippy

 

[punter]

Thanks everyone. They all work. You are the greatest.

Eddie.