How to clean up scraped data in Excel without VBA

Source: talentnett.com