I run a coaching and leadership consultancy and need to update a small database of contact email addresses and phone numbers.
There are 73 rows of school names in the file.
School Suburb Type Website Principal Principal email Phone
Alfred Deakin High School Deakin South Canberra High Website
There is no data in the principal, email and phone columns.
The principal name and the school's phone number need to be read from the website and the email constructed.
David Briggs [login to view URL](at)[login to view URL] 6142 3888
1) Make a formula to create the email address from the principal's name. The email is always of the form [login to view URL](at)[login to view URL] Therefore it can be automatically generated. Insert this into the Google sheet.
2) Extract the principal's name and the school's phone number from the website and add to the google doc. There will be 72 schools to look up.
I will give access to the google doc when we have agreed on the job.
Here is an example googlesheet with 2 names only
[login to view URL]
I will review the bids on Monday (Australia time). My apologies for this delay but I am not available for the next three days.
90 pekerja bebas membida secara purata $79 untuk pekerjaan ini
Hello sir Good morning How are you? I saw the task details and I can create formula for the emails and place the principle names of all 72 list . please contact so i can start right away thanks.
Sir, A detailed talk is needed before start. It's so good for me as well as you. I understood, the task is to ... extract phone number and contact name from websites Right?
Hi, I’m from Vietnam with a lot of experience in Excel, data entry, and web search. I would be happy to help you fill details of 72 school principals. I'm available now. I look forward to hearing from you soon, Duong