Google Search

[rs400]

I have been able to create a spreadsheet in Google Sheets which allows me to carry out multiple email searches in google.
The sheet allows me to search for
john@hotmail.co.uk|john@hotmail.com|john@live.co.uk etc.
I have replicated the exact formula used on the google sheet but each time all I get is a blank google search page and none of the search.
Is there any way I can get excel to carry out this task

 

[MartinDurham]

Are you wanting to search for a list of emails or just a single one?

This would open a search page for an email address entered into cell A1

=HYPERLINK("https://www.google.com/search?q="&A1,"Search")

 

[rs400]

Are you wanting to search for a list of emails or just a single one?

This would open a search page for an email address entered into cell A1

=HYPERLINK("https://www.google.com/search?q="&A1&",","Search")

I am hoping to do multiple searches; would | be the best way to separate the searches?

 

[MartinDurham]

What do you want to do with the results? just display them in a webpage?
What does google sheets do with the results, return the results to the sheet? (this is probably part of google sheets functionality although I think there is API for excel)

 

[rs400]

Hi Martin,
Thank you for your time.
I only want the results displayed in Google, it needs to go no further.
Your example worked perfectly for an individual email it is now just the multiples I need to acheive

 

[MartinDurham]

what is your data source? in your example it appeared to be a pipe seperated list.

If you had the emails entered into individual rows in column A you could simply drag that formula down alongside it. in column B

Sorry, I don't think I am understanding fully

 

[rs400]

I am starting off with a user name as an example john. I know john has an email but I am not sure which provider he uses.
I want to carry out a search across multiple providers to see if john has used any of the possible email addresses to post anything online.
The spreadsheet links the user name with several providers to make my searching more efficient. "john@hotmail.com" "john@hotmail.co.uk" "john@gmail.com" etc.,
Some agencies will not allow google docs on their systems so I needed to achieve the same objective in Office
I tried this process with my name and found an forum communication i had forgotten about.
I hope that makes it a little clearer