Hello

I have MS excel 2007

the file I work with is very big around 200K lines ( its a csv file)

I have a column in the file that lists email addresses

some people did not put their email address correctly.

so what I do is I do a column filter for example for anything that ends with @yahoo , and then I change the results to @yahoo.com

or for example some people put @yahoo,com , so I filter that and change the filtered results to @yahoo.com

is there way to create a macro to do different types of filters and edit the results , instead of doing each one manually?