Google Searching Cells

Hello,

your question is not clear. What do you want to do?

What URL entered in B1. The Google search URL? Or the result of the google search? Which one of the results that Google finds?

Please mock up an example in your Excel file and post that, so we know what you expect to see.

OK.

To reduce typing, create a named formula with your preferred Google page. For example, click Formulas > Name Manager > New

Enter "Google" as the name and in the Refers To box put the formula "https://www.google.com/?gws_rd=ssl#q=" (in both cases don't enter the double quotes).

Now, back in your sheet, enter this formula into cell B1 and copy down.

Please Login or Register  to view this content.

The formula will create the URL for the Google search and will at the same time put that into a hyperlink, so you can click the cell to open that URL in your default browser.

cheers, teylyn

Thanks Teylyn!

I ran into a problem though.

Check out the sheet I attached. Everything seems to be in order but when I click on the hyper link it defaults me to google home page and changes the URL.

Thanks again!!

______________________________________________

I added the word 'wallpaper' thinking that was it but the url still gets all funky on me and defaults back to the google home page

It works fine for me. Google uses different pages in different regions. I suggest you open your preferred Google page and do a search with a phrase of two or three words, like

one two three

Hit enter and inspect the URL. You'll find the search words at the end of the URL after the q=

Put the beginning of the URL including the q= into the range name as described above. That should give you the desired result.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.