How to change a specific column formatting in a spreadsheet

Hi there!   I have a huge spreadsheet, where i want to change the formatting of a certain column. The column consists of emails, but I would like to delete: text@, so that the domain name is the on...