Excel Extract numbers from a cell in excel

M

mel2131

Joined
Oct 9, 2012
Messages
10
Reaction score
0
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.






 
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.
 
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
 
Back
Top