Forum Discussion
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...
Hi Natasha,
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.