Hi

if all your strings start with four alpha followed by five numeric then use
=MID(A1,5,5)

Cheers
JulieD

"Mannyluk" wrote in message
...
Hi,

Can someone tell me the function used to ectract a number from a string??

i.e. asdf12345asdfg

to give 12345

Cheers

Manny