Google search link of text in Column A help?

Hi guys, I have been looking for this info and decided to sign up and ask.

I have a long list of Titles in Column A. I want to be able to paste a link into Column B and it automatically searches the text next to it. I would like it to be simple. Something that is the same for every row, so I can bulk copy and paste.

Thanks guys! Any help would be appreciated!

OK, thanks for the fast response.

Here is an example,

Random Title | LINK
Randsm Title | LINK

Where LINK leads to
https://www.google.com/search?q=Random+Title
https://www.google.com/search?q=Randsm+Title

Which opens in a new browser tab/window. Basically googling the info in Column A.

But I only put a generic script to get me there. So the syntax? is the same for both Column B1 and B2.

Thanks, Brian

Ok So I found this,

=HYPERLINK("http://www.google.com/search?hl=en&q=")&A2

This works, but would require me to enter the target cell every time. Also, if I adjust the rows, which I do frequently, I would break all the changed cells, the links would target the wrong cell. So what I would like help with is changing the above hyperlink to get the value from column A of the current row it is in.

Thanks, Brian

Brian, assuming there is no line breaks you can double click on the black square on the bottom right of the highlighted cell in B2 and it will correctly carry the formula down the entire row.

Marcilio, That doesn't work. It give me an error, I think 508?

Gregg, That works, but every time I change the amount of rows, I would have to delete it and redo it. If there aren't any other options it is relatively painless to just delete the column and start again after each edit... So that is an option.

Thanks so much for your replies! I am still looking for an option if anyone had ideas...

Brian

OK, so I tried adding some rows, using Gregg's idea of expanding the link to the entire column, (start with =HYPERLINK("http://www.google.com/search?hl=en&q=")&A2 and double click the black box. The links below (that change row numbers, automatically updated to the new cells, keeping their relative positions and working as I thought they should.

I think this will work, unless someone has an other idea?

Brian

You could make it an Excel table. Highlight your current region and go to the insert ribbon select table and it will automatically insert a formula when a user creates a new row.

I have this spreadsheet on my mac.... So I have been using OpenOffice instead of buying excel again (since it is on my PC) I should have stated that this needed to work with both. Also would like it to work with Google Spreadsheet as well.

I think I can make the extend selection work. I have it up and running.

Unless there are any other suggestions?

Brian

Can you run a spreadsheet event macro on those products?

I am not that up on excel programing... what would an event macro do?

Thanks for the extend selection tip. I have resorted and edited it and sorted back, all the links still work

Brian

Hyperlink.xlsm

Hi Brian,

If macros work on the other products, this workbook is updated to add a hyperlink anytime data is inserted in column A.

Thanks,

Gregg