Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
holyearth
 
Posts: n/a
Default Easy question for you all


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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Easy question for you all

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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
holyearth
 
Posts: n/a
Default Easy question for you all


Thanks so much Mr. Pearson. This worked flawlessly.

God Bless.


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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
holyearth
 
Posts: n/a
Default Easy question for you all


^bump....................^


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function question (probably easy) Dahlman Excel Discussion (Misc queries) 4 April 4th 05 03:09 PM
easy question Dahlman Excel Worksheet Functions 3 April 1st 05 11:11 PM
Easy function question Dahlman Excel Discussion (Misc queries) 2 March 31st 05 12:35 AM
Easy formula Question Excel formula fix Excel Worksheet Functions 3 March 29th 05 02:04 AM
easy question .... i think Dean Excel Discussion (Misc queries) 1 January 6th 05 06:31 PM


All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"