View Single Post
 
Old 06-10-2012, 02:01 PM
waltdisneypixar waltdisneypixar is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Jun 2012
Posts: 8
waltdisneypixar is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
• 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.

i;m using it as a movie collector, so every day i insert 2 or 3 movies with www....

i didn't understand what you said

everyday i insert name of the film, year of the film and imdb link
Reply With Quote