How to add an email address in Google Sheets/Excel?
Post date: 2021-04-08 20:49:42
Views: 91
I have a Google sheet with a column of data that contains a block of numbers and letters in each cell, like E4U8BN. There are hundreds of them, each representing a single person. I want to tag the same email address, as in "@email.com" at the end of each of those blocks. I could manually paste them on, but is there a way to automate this? A formula, perhaps?
In the end the blocks should be E4U8BN@email.com. Seems like a simple equation would do the trick but I can't figure it out. Ideally I'd like to keep it in Google Sheets but Excel would work, too.