Thread: [Solved] www....com does not stay active in excel 2010
View Single Post
 
Old 06-08-2012, 11:05 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
• In a spare column, input: =HYPERLINK(A1)
• Copy down as far as needed
• Select the data in the 'spare' column
• Copy the data
• Use Edit | Paste Special > Values
• Copy the data
• Paste over the original data
• Delete the 'spare' column.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote