Hello!
I have a need for a formula based data extraction/verification method. I receive a list of values, which is not always in the correct format.
I need to extract a 7 digit string which is alpha for the first three characters, and numeric for the last four. For example, AAA0001 to ZZZ9999
The problem is, sometimes the number in the cell is surrounded by other characters of varying length, both letters and numbers (there will only be one occurrence of the number/format I need to extract), it could be the first 7 digits of a string, the last 7, somewhere in the middle. Sometimes it is separated by a character I can delimit by such as a "-", but when this is the case the number I need is not always in the same delimited location and ends up in in different columns on half of the rows.
Short version is I need a formula that will find a string of three letters followed by numbers and return that value, regardless of it's position within a cell.
Thanks in advance!
Bookmarks