Strip 6 numbers out of a string (EASY POINTS!)

[Anonymous]

Please strip the 6 digit number that starts with a '6' out of this alphanumeric string:

KL20000000621103EDLBR

So i only need 621103. Please help and points will be awarded fast. Thanks!

[sunny_talwar · Accepted solution]

May be this

=Mid('KL20000000621103EDLBR', Index('KL20000000621103EDLBR', '6'), 6)

[Anonymous]

thats super hawt, thanks