Please ensure that the LEFT function is preceded by double negatives. I’m replying through mobile phone so the double negatives don’t appear as they should be.
Have you tried "text to columns" on the "data" tab? If there is a space between '1234' and 'miles', you can click on "fixed width" and every section will appear in its own column. Just add enough columns next to the cells that contain too much info. Once done, you can delete unwanted columns and keep only the info you need.
