• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Putting in email adresses

Hi,
I have about 200 names in column A and I want to add @gmail.com to all of the names, how do I do this?
Thanks for your help
Noel
 
Noel Lackey
Write to cell B1 = A1 & "@gmail.com" and copy down as long as needed.
If needs to have those in A-column then ... move B-column values to A.
 
Noel Lackey
Have You ever moved from house to house?
or moved a chair to other room?
=> click "B"-letter in header
=> You should be selected B-column (should see some highlite)
=> Move Your mouse over line between B & C-columns
=> Mouses-cursor would change as hand
=> Press gently Mouses left button
=> Move mouse left ... until You'll see A:A
=> Release Your mouse ... and breath.

If still challenges then upload a sample file here.
 
Noel Lackey
Have You ever moved from house to house?
or moved a chair to other room?
=> click "B"-letter in header
=> You should be selected B-column (should see some highlite)
=> Move Your mouse over line between B & C-columns
=> Mouses-cursor would change as hand
=> Press gently Mouses left button
=> Move mouse left ... until You'll see A:A
=> Release Your mouse ... and breath.

If still challenges then upload a sample file here.
 

Attachments

  • Sample.xlsx
    9.8 KB · Views: 2
Back
Top