Example:
I have imported a list of email addresses (6000 rows). The data in each cell looks like this:

email address:[email protected].

I need a macro to delete "email address:_" in each cell (_ being a space).

I tried the macro recorder and cannot get it to work. HELP!