Editing of text in Google Sheets and collection of URLs

I require the editing of text and collection of URL’s where missing, from a file of exhibitors at tradeshows around the world. Work is batched up into approximately 4-hour bundles.
The job is quite simple data tidying, but some skills in text manipulation in google sheets is highly valued + there is a bit of google required if the data isn’t provided.

A full guide is provided to help in the process (please see attached).

With thanks

Sinead