Hi, I receive an exported dump of data which contains an alpha numeric string of characters which I manually have to separate.
The logic is column B needs to display the code (prefixed with 'A10'). I need this to return the full 9 character code, plus any numbers which immediately follow the semicolon.
Column C shows the Customer code - this is an alpha numeric code which contains 7 characters.
Any other parts of the string which is outside of this logic, such as 'ABC' or '256464565465465' needs to be ignored.
Many thanks for your help.
Bookmarks