Extract Exact 6 Digit Number From String

Hi,

I have a data set with combination of alphabets and numbers in Column A. I would like to find a formula or vb codes that can extract the string with exact 6 digital in column B. For example

TestData 123456 TestTest ---> Return 123456
TestData 123456789 TestTest ---> Return Blank (nothing)
TestData 244123456 TestTest 987654 ---> Return 987654


Any assistance is appreciated.

Thanks.

Please Login or Register  to view this content.

usage:
=Get6Digits(A1)
for instance