up vote 2 down vote favorite
share [g+] share [fb]

How can I add @gmail.com or something similar to a column of usernames without having to type this into each cell? I am using Excel 2010. I have a list of several hundred usernames that need to have @gmail.com or something similar added to create a csv file for upload.

link|improve this question
feedback

3 Answers

up vote 5 down vote

Assuming your names are in column starting from A1, you can use the formula:

=A1&"@gmail.com"
link|improve this answer
1  
+1 - But could also make cell Ax = "@gmail.com" and make the formula =A1&Ax. Then if change required, only one cell to change – Wayne Sep 13 '11 at 3:47
@Wayne, I was thinking the same thing just after I posted this but thought I'd keep it simple. Also, by Ax do you mean B1 and =A1&B1? – Hand-E-Food Sep 13 '11 at 4:57
I was meaning A<somecol> (as in any column) maybe a small italic n would have been better suited. – Wayne Sep 13 '11 at 13:23
Ah. Columns are lettered and rows are numbered. A represents the column, so A1 and Ax are in the same column. That's where my confusion was with your comment. – Hand-E-Food Sep 14 '11 at 4:24
feedback
up vote 2 down vote

If you need to change the value of the cells, I'd recommend Hand-E-Food's solution. (If you need to keep it in one column, just Copy, then Paste Special > Values back to the original column.)

However, if you want it to simply display the suffix without actually altering the cells' values, you can use a custom number format instead. In Excel 2007 or later, select Custom in Home > Number. In earlier versions, it's Format > Cells > Number. Use @"@gmail.com" as the custom format.

In this screen shot, column A is using a custom format as I describe. Column B is using Hand's solution (you can see the formula in the center right).

Excel custom formatting example

link|improve this answer
feedback
up vote 1 down vote

Let's say your usernames are in column A starting from A1. Go to B1, enter the following formula and drag it down till the end of the row where the list ends (or you can simply double click on the lower right corner of the cell).

=CONCATENATE(A1,"@gmail.com")
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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