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