Quote:
Originally Posted by macropod
• 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.
|
copy down as far as needed: what do i have to copy?
• Select the data in the 'spare' column: how?
• Copy the data : what do i have to copy, again?
Use Edit | Paste Special > Values : where is it?
• Copy the data : what do i have to copy, again?