Is there a tool to do a simple edit to every cell in a particular column?

[rmartori]

At our company has two  emails for everyone, one that is just the company name and one that is US.Companyname.com

With part of what I am working on we are searching by the normal email as we are slowly going away from the other. So what I want is to go through the email column and any instance of "US." I want removed so instead of rmartori@us.comp.com it becomes rmartori@comp.com.

[PhilipMannering · Accepted solution]

Try this,

replace([Email], 'us.', '')