How to Add a Comma at the End of text or numbers in Excel -5 Methods

This is a sample dataset.

Method 1 – Adding the Ampersand (&) Operator

Steps:

Select C5 and enter the formula.

=B5&”,”

The Ampersand (&) sign will add the comma at the end of the text in B5.

Press ENTER and drag down the Fill Handle tool to fill the other cells.

This is the output.

Method 2 – Using the CONCATENATE Function

The CONCATENATE function adds two or more text strings and transforms it into another string.

Steps:

Go to C5 and insert the formula.

=CONCATENATE(B5,”,”)

Press ENTER and drag the formula to see the result.

Read More: How to Use Comma in Excel Formula

Method 3 – Using the SUBSTITUTE Function

The SUBSTITUTE function replaces a specific character with another.

Steps:

Go to C5 and enter the formula.

=SUBSTITUTE(B5,”-“,”,”)

Press ENTER and drag down the Fill Handle to see the result.

Method 4 – Utilizing the TEXTJOIN Function

The TEXTJOIN function joins two or more text strings with a special character. The dataset below contains Student IDs and Marks.

Steps:

In E5, enter the formula.

=TEXTJOIN(“,”,TRUE,B5:D5)

Press ENTER.

This is the output.

Method 5 – Applying VBA to Add a Comma at the End of a text or number

Steps:

Go the Developer tab >> select Visual Basic.

In the dialog box, go to the Insert tab.
Click Module >> select Module1 >> Enter the code.

Public Sub InsertComma()
Dim LastRow As Long, C As Integer, R As Long
C = 2  
LastRow = Cells(Rows.Count, C).End(-4162).Row
Application.ScreenUpdating = False
For R = 5 To LastRow
    Cells(R, C + 1) = Cells(R, C) & "," 
Next
Application.ScreenUpdating = True
End Sub

Press F5 to run the code.
This is the output.

How to Add a Comma at the End of Numbers in Excel

You can use the Comma Style feature to add the commas at the end of numbers.

Steps:

Select the entire data range.
Go to the Home tab and in Number, click Comma Style.

Press CTRL + 1 to open the Format Cells dialog box.
Go to Number >> Enter 0 in Decimal Places >> check Use 1000 Separator (,) >> click OK.