I am trying to isolate the employeeID and name from a long string which contains many records with this information. I want to extract the 2 fields per record from the string and store them in a range on the excel sheet.
The problem is the data is not normalized. Sometimes it has employee ID and name for each record, sometimes just a name and sometimes the string has both types in the same string.
If I can find the no visible character in the string which separates the records it should be fairly easy to separate the records and then extract the data from each record
I attach an excel file and would love to get some code which can extract the data from the 3 cases on the sheet
I have spent hours getting lost in endless loops on this but I know the best way is to find the record breaker first I just don't know What it is