Welcome to the MrExcel forum.
What version of Excel and Windows are you using?
Can we see more examples of the strings?
Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?
To post your data, you can download and install one of the following two programs:
MrExcel HTML Maker
Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link: