Excel Extract numbers from a cell in excel

[mel2131]

Hi,
If anyone could help I would be very happy, tried a few things already but none of them work.
I have this info in the K column 407137 - 4103244 - e23
and I want to extract just the 4103244

Any help would be appreciated. I thought it would be the MID function but its not working for me.

Mel.

 

[alow]

If every cell in K has the same number of digits/characters in the same pattern, you would use the following formula:

=MID(K2,10,7)

Assuming that the first digit is the 10th character and you are starting in row 2. Let me know if that does it, or if your data is non-standard, there are other ways.

 

[mel2131]

perfect, thanks very much.
the formula i was using was =mid(k2,10,11,12,13,14,15,16) which obviously didnt work for me!!

THANKS AGAIN

 

[alow]

Glad it worked out for you!