Good afternoon gurus,
I have over 2,000 of rows in a sheet. In cell A2 with a string of alphanumeric. What I would like to do is extract from cell A2 to a different cell that starts with 1X,2X,3X, and 4X (11digit long) to a different cell. Please help fix this code that can do more than one criteria.
=MID(A2,MIN(SEARCH("1X?",A2,1),SEARCH("1X?",A2,1)),11)
Thank you
Bookmarks