I wanted to find a way to add a string into the middle of emails in Google sheets. For example:

We have 5 rows:

bus@email.com

car@email.com

truck@email.com

train@email.com

plane@email.com

I want to change these emails to this form:

bus+test@email.com

car+test@email.com

truck+test@email.com

train+test@email.com

plane+test@email.com
New contributor
Allan is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

If your list of e-mails is on column A, use the following formula to achieve the desires result:

=substitute(A1,"@","+test@")

You might want to copy & paste as text depending on how you will use the e-mails.

Your Answer

Allan is a new contributor. Be nice, and check out our Code of Conduct.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.