Append same text to every cell in a column in Excel

Question

How can I append text to every cell in a column in Excel? I need to add a comma (",") to the end.

Example:

[email protected] turns into [email protected],

Data Sample:

[email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] [email protected] 

Answer 1

See if this works for you.

• All your data is in column A (beginning at row 1).
• In column B, row 1, enter =A1&","
• This will make cell B1 equal A1 with a comma appended.
• Now select cell B1 and drag from the bottom right of cell down through all your rows (this copies the formula and uses the corresponding column A value.)
• Select the newly appended data, copy it and paste it where you need using Paste -> By Value

That's It!

Answer 2

It's a simple "&" function.

=cell&"yourtexthere" 

Example - your cell says Mickey, and you want Mickey Mouse. Mickey is in A2. In B2, type

=A2&" Mouse" 

Then, copy and "paste special" for values.

B2 now reads "Mickey Mouse"