Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell containing text and a web link. How can I format the web link
to be clicked once to visit the website like the same put in an individual cell. Thanks, Scott |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't have a direct solution, but if you need to keep the cell as is with
the link and text, you can create adjacent cells that split them off, using the function =left(cell row and column, number of characters) for the stuff on the left, and =right((cell row and column, number of characters) for the stuff on the right. "Scott" wrote: I have a cell containing text and a web link. How can I format the web link to be clicked once to visit the website like the same put in an individual cell. Thanks, Scott |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Show it to us. A hyperlink perhaps -- Don Guillett Microsoft MVP Excel SalesAid Software "Scott" wrote in message ... I have a cell containing text and a web link. How can I format the web link to be clicked once to visit the website like the same put in an individual cell. Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i remove an excel link that break link won't remove | Excel Worksheet Functions | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Link to external link | Excel Worksheet Functions |