Change Hyperlink to Plain Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column has data that I would like to displayed as plain text to users instead
of having a hyperlink associated with it.

I can do one cell at a time but how would I do an entire column?
 
If you are not familar with working in VBA you can highlight the whole
column, Press Ctrl C to copy the contents. Then rightclick the first row and
click 'paste Special'. Select the 'Values Only' radio button and hit Okay.
That should eliminate all the hyperlinks and leave their text Values.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks in plain text? 1
Hyperlinks 1
hyperlinks and plain text in same cell? 4
Hyperlink from plain text. 2
Activating hyperlinks 3
Open specific hyperlink (accept) automatically in email with outlook 0
Excel Hyperlink-show link 2
Excel Hyperlink 0

Back
Top