How to extract text before/after space or comma only in Excel?

Source: d2d42mpnbqmzj3.cloudfront.net