Hyperlinks and Excel

funkylad20 | 16:18 Mon 16th Jul 2007 | Computers

2 Answers

I have a spreadsheet with email addresses on. I need to input all of these email addresses onto a database,. Everytime I click the 'email address' cell, it automatically tries to generate an email. I have sussed out how to 'remove the hyperlink' (i.e. simply making it a text field using '1', copy, paste special etc) BUT I need to make them all proper working hyperlinks to email addresses once again when I have finished. Any ideas?!

wat is program status word

System Tray

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by funkylad20. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Hawkeye99

On Excel 2003:
If you need to select a cell that Excel has converted to an email address click and keep the mouse button pressed.
After a second Excel will select the cell rather than trying to generate the email.
If this works for you then it will avoid the need to make it an ordinary text field in the first place.

spreadsheets

Just copy the column with the hyperlinks and paste special it as value in another column and use that to enter into the database leaving the hyperlinks intact.

Can you not just upload the file into the database?

1 to 2 of 2

Do you know the answer?