pmeghnathi
Board Regular
- Joined
- Mar 11, 2018
- Messages
- 98
- Office Version
- 2003 or older
- Platform
- Windows
How to Excel cell concotenet text url click to open url link in browser?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to Excel cell concotenet text url click to open url link in browser?
Excel Facts
Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Hi.
Please try using google.translate.com to get a clearer question in English
Meantime, use
..in Column B to get a result like this :
[TABLE="width: 241"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Product Code[/TD]
[TD]Product Information[/TD]
[/TR]
[TR]
[TD]XYZ123[/TD]
[TD]Lookup Product[/TD]
[/TR]
[TR]
[TD]XDS888[/TD]
[TD]Lookup Product[/TD]
[/TR]
[TR]
[TD]JBC665[/TD]
[TD]Lookup Product[/TD]
[/TR]
</tbody>[/TABLE]
Cheers.
Warren K.
Please try using google.translate.com to get a clearer question in English
Meantime, use
Code:
=HYPERLINK("somewebsite.com/products/" &A2 & ".html","Lookup Product")..in Column B to get a result like this :
[TABLE="width: 241"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Product Code[/TD]
[TD]Product Information[/TD]
[/TR]
[TR]
[TD]XYZ123[/TD]
[TD]Lookup Product[/TD]
[/TR]
[TR]
[TD]XDS888[/TD]
[TD]Lookup Product[/TD]
[/TR]
[TR]
[TD]JBC665[/TD]
[TD]Lookup Product[/TD]
[/TR]
</tbody>[/TABLE]
Cheers.
Warren K.
Upvote
0
