find 12 characters in a string
Posted on 2014-10-22
is it possible to find 12 characters within a string, [but with a catch]
I will have a lookup table that will have a list of shrortened currency codes, so US, GB, CH, HK etc.
I need to look up this table and the find the code within the string that starts with US or GB or CH etc
so if the cell contains this:
GSB142839981001 //TAG1410210509596 1710598400 US455760CW45 SALE [in column 'N in sheet called RawData]
I need to extract US455760CW45
The Static codes will be in a sheet called Static in column 'A'
The cell containing the data will be in a sheet called RawData in Column 'N'
and I need to put the resultant answer [US455760CW45] in column 'O'
Is this doable?
Thanks in advance