Add the same text to each cell in an Excel column

Question

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

Example:

[e-mail] becomes [e-mail],

Sample data:

 [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] [e-mail] 

Answer 1

See if this works for you.

• All your data is in column A (starting from row 1).
• In column B, row 1, enter = A1 & ","
• This will make cell B1 equal to A1 with a comma added.
• Now select cell B1 and drag it in the lower right corner of the cell down all your rows (this copies the formula and uses the corresponding value of column A.

What is it!

Answer 2

This is a simple & function.

 =cell&"yourtexthere" 

Example: your cell says Mickey, you want Mickey Mouse. Mickey is in A2. In B2 enter

 =A2&" Mouse" 

Then copy and paste the special values ​​for the values.

 B2 now reads "Mickey Mouse" 

Answer 3

Plain...

 =CONCATENATE(A1,",") 

Example : if [e-mail] is in cell A1, then write to another cell = CONCATENATE (A1, ",")

[e-mail] after this formula you will receive [e-mail],

To delete a formula : copy this cell and use alt + e + s + v or paste in a special value.

Answer 4

No need to use extra columns or VBA if you want to add a character to display.

As this post offers you everything you need to do:

• Select the cell (s) you want to apply formatting to
• Go to the Home tab
• Click Number
• Choose Custom
• In the Type text box, enter the formatting you want by placing the number zero inside any characters you want.

An example of such text for formatting:

• If you want to save cell value 120.00 for reading $120K , enter $0K

Answer 5

pretty simple .... you can put all of them into a cell using the comcatenate function

 =CONCATENATE(A1,", ",A2,", ", and so on) 

Answer 6

Select a range of cells, enter a value and press Ctrl + Enter. This, of course, is true if you want to do it manually. If you want to do this in code, please be more specific about what you use.

Answer 7

I just wrote this for another answer: You would name it using the form using your example: appendTextToRange "[theRange]", "," .

 Sub testit() appendTextToRange "A1:D4000", "hey there" End Sub Sub appendTextToRange(rngAddress As String, append As String) Dim arr() As Variant, c As Variant arr = Range(rngAddress).Formula For x = LBound(arr, 1) To UBound(arr, 1) For y = LBound(arr, 2) To UBound(arr, 2) Debug.Print arr(x, y) If arr(x, y) = "" Then arr(x, y) = append ElseIf Left(arr(x, y), 1) = "=" Then arr(x, y) = arr(x, y) & " & "" " & append & """" Else arr(x, y) = arr(x, y) & " " & append End If Next Next Range(rngAddress).Formula = arr End Sub 

Answer 8

Select the column and then cntrl + f. Find and replace find ".com" replace ".com",

and then one for .in find and replace find in "replace" .in ",

Answer 9

Put the text / value in the first cell, then copy the cell, check the whole colum and paste the copied text / value.

This works in Excel 97 - it’s a pity there is no other version on my side ...

Answer 10

Enter it in one cell, copy this cell, select all the cells you want to fill, paste.

Alternatively, enter it in one cell, select the black square in the lower right corner of this cell, drag down.