Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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
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.
