Home

How to change a specific column formatting in a spreadsheet

natasha goldsmith
Occasional Visitor

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 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? 

 

 Screen Shot 2017-10-03 at 20.52.14.png

 

2 Replies

Re: How to change a specific column formatting in a spreadsheet

use below formula

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

Re: How to change a specific column formatting in a spreadsheet

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.

Related Conversations
Linking OneDrive to New Microsoft Teams Channel
Kelly Charlton in Microsoft Teams on
3 Replies
Adding an Existing OneNote notebook to Teams
CC Adeyemo in Microsoft Teams on
18 Replies
Create private channel in a team
Catalin Prata in Microsoft Teams on
84 Replies
No Assignments Tab in Microsoft Teams
Nick Davies in Microsoft Teams on
26 Replies