Excel Substitute Formula with examples

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.

Continue reading “Excel Substitute Formula with examples”