| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing Hyperlink
I've cut and pasted names from a website into Excel, but when I click in
the cell it connects to that hyperlink. How can I prevent this and have it be just normal text? Thanks to anyone who can help me! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing Hyperlink
Copy an empty cell, select the names with the links using the arrow keys, do
editpaste special and select add -- Regards, Peo Sjoblom "joaniemic" wrote in message ... I've cut and pasted names from a website into Excel, but when I click in the cell it connects to that hyperlink. How can I prevent this and have it be just normal text? Thanks to anyone who can help me! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing Hyperlink
In the future, you can use Paste Special/Values to capture the text
without any formatting or links. On Apr 30, 9:42 am, joaniemic wrote: I've cut and pasted names from a website into Excel, but when I click in the cell it connects to that hyperlink. How can I prevent this and have it be just normal text? Thanks to anyone who can help me! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing Hyperlink
Run this simple macro to delete all web objects:
Sub DeleteWebObjects() Cells.Hyperlinks.Delete ActiveSheet.Pictures.Delete End Sub Or,,,,,,,,,,, Data Import New Web Query ... navigate to the site you want to import data from click the yellow arrow so it turns green (you can select several) and click 'Import'. Regards, Ryan--- -- RyGuy "Reitanos" wrote: In the future, you can use Paste Special/Values to capture the text without any formatting or links. On Apr 30, 9:42 am, joaniemic wrote: I've cut and pasted names from a website into Excel, but when I click in the cell it connects to that hyperlink. How can I prevent this and have it be just normal text? Thanks to anyone who can help me! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing Hyperlink
Thank you so much... it worked!
"Peo Sjoblom" wrote: Copy an empty cell, select the names with the links using the arrow keys, do editpaste special and select add -- Regards, Peo Sjoblom "joaniemic" wrote in message ... I've cut and pasted names from a website into Excel, but when I click in the cell it connects to that hyperlink. How can I prevent this and have it be just normal text? Thanks to anyone who can help me! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Mail to: hyperlink option | Excel Discussion (Misc queries) | |||
| Removing a hyperlink when right click doesn't open shortcuts? | Excel Worksheet Functions | |||
| Can I remove a hyperlink without removing the color of the cell? | Excel Discussion (Misc queries) | |||
| Removing Hyperlink | Excel Discussion (Misc queries) | |||
| Removing hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
