How to change a specific column formatting in a spreadsheet

[natasha goldsmith]

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 only thing left. 

For example: michael@mhc-uk.com --> mhc-uk.com

In the picture I've done it manually for the first 5 ones, but is there a way so that i do them all in one bulk? 

 

[#2]

use below formula

=RIGHT($BO18,LEN($BO18)-FIND("@",$BO18))

[#3]

Hi Natasha,

Perhaps the fastest way is to use in ribbon Data->Text to columns using "@" as delimeter.

https://support.office.com/en-us/article/Merge-and-unmerge-cells-in-Excel-for-Mac-f4ef88e4-5a79-402b...

Not sure if Flash Fill is available for Excel on Mac, on Windows version that's also a fast to do option.