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.