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

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

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