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.