Try

="http://www.someurl.com/some.php?q="&A1



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"holyearth"
wrote in
message
...

Ok here we go..

The cell value for A1 is "POTATO"

I want to plug in the value of A1 (Potato) into this url as a
value
Q...
The cell value for A2 is http://www.someurl.com/some.php?q=[THE
CONTENT
OF A1]...



How can I achieve this?

Normally, I'd just put =A1 but since I've got other text in the
cell,
that doesn't work.....


--
holyearth
------------------------------------------------------------------------
holyearth's Profile:
http://www.excelforum.com/member.php...o&userid=34022
View this thread:
http://www.excelforum.com/showthread...hreadid=537827