Creating custom hyperlinks based on input text?

[mrexcel888]

basically i am not sure if this would be the best way to do this hence why i thought i would ask you for any advice.

I want to create something which will search a number of custom websites for the "keyword" that i input.

So lets say that i have these websites, google, yahoo, amazon. and their search entry is www.google.com/search="keyword", so if i wanted to search for a lawnmower all i would need to do is to type in "john doe" into A1 and then it would produce the www.google.com/search=john doe, www.yahoo.com/search=john+doe, www.amazon.com/search=john&doe links and then i could click on maybe a button or macro which would open up all 3 sites into one window for me.

Obviously the search string for google isn't as simple as "/search=keyword" and the "keyword" isnt always at the end of the website address, sometimes it is in the middle, so i guess it might look something like this?

1st part of search text	1st keyword	website specific	2nd keyword	combined text/hyperlink
	john		doe
www.yahoo.com/search=				www.yahoo.com/search= john doe
www.google.com/search=		+		www.google.com/search=john+doe
www.amazon.com/search=		&		www.amazon.com/search=john&doe
macro or button to open all links

thats the simplest way i could think of how to do this, although i think there are obviously more easier or user-friendly ways of doing this. Hence why i am asking you guys for advice. Thanks!

[JBeaucaire]

You can use the HYPERLINK() formula to construct a clickable hyperlink from pieces of text.