-1

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
0

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

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.