Web link

[Scott]

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

 

[Peter]

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

 

[Don Guillett]

Show it to us. A hyperlink perhaps