Excel email links to view

I have an Excel spreadsheet with names that have a hyperlink for their emails.    I want to see the emails as a column, not just when I roll over or click.    Is their a way to do this?