Insert comma to end of a cell
This tutorial shows how to add a comma (,) to the end of a cell through the use of an & sign and CONCATENATE function, or VBA
=B5&","
=B5&C5
|
GENERIC FORMULA
=cell&","
ARGUMENTS GENERIC FORMULA
=cell&comma
ARGUMENTS EXPLANATION This formula uses the & sign to add a comma at the end of a cell.
Click on either the Hard Coded or Cell Reference button to view the formula that has the comma sign to be inserted directly entered into the formula or referenced to a specific cell that captures the comma sign.
In this example we are adding a comma at the end of a string captured in cell (B5). |
=CONCATENATE(B5,",")
=CONCATENATE(B5,C5)
|
GENERIC FORMULA
=CONCATENATE(cell,",")
ARGUMENTS GENERIC FORMULA
=CONCATENATE(cell,comma)
ARGUMENTS EXPLANATION This formula uses the CONCATENATE function to insert a comma at the end of a string captured in a cell.
Click on either the Hard Coded or Cell Reference button to view the formula that has the comma sign to be inserted directly entered into the formula or referenced to a specific cell that captures the comma sign.
In this example we are adding a comma at the end of a string captured in cell (B5). |
Dim ws As Worksheet
ws.Range("C5") = ws.Range("B5") & ","
End Sub
Dim ws As Worksheet
ws.Range("D5") = ws.Range("B5") & ws.Range("C5")
End Sub
Dim ws As Worksheet
'insert a comma to end of a string
For x = 5 To 8
ws.Range("C" & x) = ws.Range("B" & x) & ","
Next x
End Sub
Dim ws As Worksheet
'insert a comma to end of a string
For x = 5 To 8
ws.Range("D" & x) = ws.Range("B" & x) & ws.Range("C" & x)
Next x
End Sub
Related Topic | Description | Related Topic and Description |
---|---|---|
Insert a comma after each word | How to insert a comma after each word through the use of an Excel formula or VBA | |
Insert a comma before each word | How to insert a comma before each word through the use of an Excel formula or VBA | |
Insert full stop to end of a cell | How to add a full stop (.) to the end of a cell through the use of an Excel formula or VBA | |
Add value to end of a cell | How to concatenate a value to the end of a cell through the use of an Excel formula or VBA |