If this is something you do just once in awhile rather than several
times in a given workbook, you might also consider the following.
When you type an email address or a URL into a cell, 2 actions
actually take place even though it appears as just 1. (1) Your entry
is accepted as text when you hit Enter, and (2) Excel then immediately
transforms your entry to a hyperlink. Since the Undo function undoes
the last action, simply do Ctrl+Z (or Edit>Undo) and that last action
of Excel transforming your text to a hyperlink will be undone, and
your entry will return to being just text.