Hi,
I have a column of keywords in Excel that I would like to convert to hyperlinks with a macro. I would like the hyperlink url to be concatenated with a variable equal to the keyword in the cell. I would also like any spaces in the words of the cell to be translated to "+" sings in the url. Can anyone help? This seems like an easy macro but I don't know VBA programming to do this yet:
Example:
eye candy
candy
Turns to hyperlinked words
eye candy (candy (
THANKS!!
chomp99
I have a column of keywords in Excel that I would like to convert to hyperlinks with a macro. I would like the hyperlink url to be concatenated with a variable equal to the keyword in the cell. I would also like any spaces in the words of the cell to be translated to "+" sings in the url. Can anyone help? This seems like an easy macro but I don't know VBA programming to do this yet:
Example:
eye candy
candy
Turns to hyperlinked words
eye candy (candy (
THANKS!!
chomp99