Excel File/String Manipulation


I am now able to finally extract all information necessary from a webpage (much thanks to Aksh & Vvaidya!) however the output needs to be formatted just a tad.

Here is the excel file: MD_Cawp.xlsx (16.6 KB)

I need help with these 3 things:

1.) In the ‘Contact_Number’ column there is an extra “phone” string that is after the actual phone number, would like to trim that but unsure how.

2.) In the ‘Reviews’ column I need to split the amount of reviews from the score and put into two separate columns.

3.) In the ‘Specialty’ column I need to get rid of the ’ | ’ symbol that is attached on each line.

Any and all help is much appreciated.

Thanks as always.

I believe all of these are explained in this video