200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Worksheet "Prod issues Report 04022019"
Tab "Full"
Column K - This column has 6-12 character numbers in them that i need to extract into column S. Some numbers start with IL or AB and also can end with t.
Is there a formula or VBA Code (even better) to extract these numbers with this criteria into column S with the corresponding Row.
HI
I have had a quick look at your problem. The trick is there does not appear to be any simple rule to Identify the code.(we won't call it a number)
In a number of cases you could take all the characters to the first blank space. You would needs some rules around th hyphen. and I have noticed that sometimes the hyphen has a space around it.
The next chanlenge is where the number is not first but appears somewhere in the text.
It is a job for artificail intaligence.
I would try using a macro and use the split command on the space then look at each element and choose the one which has at least 6 numbers. If you need the hyphen check the next element and concatenate if required.
I have added a function to your excel which does some stuff
