| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Hyperlink to Plain Text
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Hyperlink to Plain Text
try
columns(1).hyperlinks.delete -- Don Guillett SalesAid Software "Sam" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Hyperlink to Plain Text
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. "Don Guillett" wrote: try columns(1).hyperlinks.delete -- Don Guillett SalesAid Software "Sam" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change number format from text to number? | New Users to Excel | |||
| Converting hyperlink picture object to hyerlink text | Excel Discussion (Misc queries) | |||
| How do I change the default cell formatting to be text? | Excel Discussion (Misc queries) | |||
| Right clicking on text does not bring up hyperlink option | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Linear Mode
