Removing Text and Leaving just numbers

hey guys

i have a sheet dealing with part numbers and a paramiter exported from a programme.

L=1000MM | L/R is an example.

now
i use replace to get rid of everything before the number but anything after the mm is totaly different most of the time.
is there a way that i can get rind of anything after, and including, the mm?
or by some chance a command that will just leave me with the number allone??

Ps: sorry about the title before was totaly incorrect

A sample would be helpful in this instance such that we can determine the ranges in play etc... presumably you're looking to replace the actual value in the same cell... else you could use formulae in an adjacent cell.

a full example would be a bit large and over complicated
but i have attached somthing that i think gets what i am after
no i am looking to keep the cell as is
but the number is a length i need to multiply by a price per mm.

Perhaps:

Please Login or Register  to view this content.

no i need it in visual basic

Using your approach (not mine I should add)

Please Login or Register  to view this content.

hmm
sounds like u have a better idea than me
i am always open to learning a few things
i am self taught in vba from sites like these so i can be a little sloppy at times

thanks for that DonkeyOte

works just how i wanted it to
any chance of explaining the split and val functions to me ive had a look and cant quite figure it out

val seems to return the numbers at the start of a string
is that right??

The Split will split the string based on the Delimiter specified.

Assuming then a string of:

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

Will generate 2 substrings (0 & 1):

Please Login or Register  to view this content.

Thus Split(str,"=")(1) refers to the 2nd sub string

Please Login or Register  to view this content.

thus returns 1000 -- it will stop reading as soon as it finds a non-numeric character (period character excepted)

that was exactly what i wanted
well put
thanks alot