File attached below, The data between A2:A71 is already formatted using test to columns and the data below this from A72:A93 is unformatted.
Thanks Again

Example_2.xlsm