Problem:
In column A I have a list of email addresses, I want to put these into column B but in the same cell I want to add another line with a new email address – based on everything before the domain of old email address.
So basically I want to substitute everything with the original text string with my new text string.