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: firstname.lastname@example.org --> 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?
use below formula
Perhaps the fastest way is to use in ribbon Data->Text to columns using "@" as delimeter.
Not sure if Flash Fill is available for Excel on Mac, on Windows version that's also a fast to do option.