Ok here we go..
The cell value for A1 is quot;POTATOquot;
I want to plug in the value of A1 (Potato) into this url as a value
Q...
The cell value for A2 is 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: www.excelforum.com/member.php...oamp;userid=34022
View this thread: www.excelforum.com/showthread...hreadid=537827
^bump....................^--
holyearth
------------------------------------------------------------------------
holyearth's Profile: www.excelforum.com/member.php...oamp;userid=34022
View this thread: www.excelforum.com/showthread...hreadid=537827Try
=quot;www.someurl.com/some.php?q=quot;amp;A1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;holyearthquot;
gt; wrote in
message
...
gt;
gt; Ok here we go..
gt;
gt; The cell value for A1 is quot;POTATOquot;
gt;
gt; I want to plug in the value of A1 (Potato) into this url as a
gt; value
gt; Q...
gt; The cell value for A2 is www.someurl.com/some.php?q=[THE
gt; CONTENT
gt; OF A1]...
gt;
gt;
gt;
gt; How can I achieve this?
gt;
gt; Normally, I'd just put =A1 but since I've got other text in the
gt; cell,
gt; that doesn't work.....
gt;
gt;
gt; --
gt; holyearth
gt; ------------------------------------------------------------------------
gt; holyearth's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34022
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=537827
gt;
Thanks so much Mr. Pearson. This worked flawlessly.
God Bless.--
holyearth
------------------------------------------------------------------------
holyearth's Profile: www.excelforum.com/member.php...oamp;userid=34022
View this thread: www.excelforum.com/showthread...hreadid=537827
- Sep 29 Fri 2006 20:09
Easy question for you all
close
全站熱搜
留言列表
發表留言