In the attached workbook I am looking for a formula or an edit to the current function that will split out text and numbers from a cell. The function currently works as shown in row three of the workbook and splits out data as required. However the data (which is downloaded from the web), has changed in certain instances (see row 53) and the function no longer works correctly for those instances.
Any help will be appreciated.
Thank you in advance as always,
BigDawg15
Bookmarks