Insert full stop to end of a cell

This tutorial shows how to add a full stop (.) to the end of a cell through the use of an & sign and CONCATENATE function, or VBA

EXCEL FORMULA 1. Insert full stop to end of a cell using the & sign

EXCEL

Hard coded formula
Insert full stop to end of a cell
Cell reference formula
Insert full stop to end of a cell
=B5&"."
=B5&C5
GENERIC FORMULA

=cell&"."

ARGUMENTS
cell: A cell at the end of which you want to insert a full stop (.).

GENERIC FORMULA

=cell&full_stop

ARGUMENTS
cell: A cell at the end of which you want to insert a full stop (.).
full_stop: A cell that contains the full stop sign.

EXPLANATION

This formula uses the & sign to add a full stop at the end of a cell.
Click on either the Hard Coded or Cell Reference button to view the formula that has the full stop sign to be inserted directly entered into the formula or referenced to a specific cell that captures the full stop sign.

In this example we are adding a full stop at the end of a string captured in cell (B5).

EXCEL FORMULA 2. Insert full stop to end of a cell using the CONCATENATE function

EXCEL

Hard coded formula
Insert full stop to end of a cell
Cell reference formula
Insert full stop to end of a cell
=CONCATENATE(B5,".")
=CONCATENATE(B5,C5)
GENERIC FORMULA

=CONCATENATE(cell,".")

ARGUMENTS
cell: A cell at the end of which you want to insert a full stop (.).

GENERIC FORMULA

=CONCATENATE(cell,full_stop)

ARGUMENTS
cell: A cell at the end of which you want to insert a full stop (.).
full_stop: A cell that contains the full stop sign.

EXPLANATION

This formula uses the CONCATENATE function to insert a full stop 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 full stop sign to be inserted directly entered into the formula or referenced to a specific cell that captures the full stop sign.

In this example we are adding a full stop at the end of a string captured in cell (B5).

VBA CODE 1. Insert full stop to end of a cell

VBA

Hard coded against single cell
Sub Insert_full_stop_to_end_cell()
'declare variables
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'insert a full stop to end of a string
ws.Range("C5") = ws.Range("B5") & "."

End Sub

Cell reference against single cell
Sub Insert_full_stop_to_end_cell()
'declare variables
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'insert a full stop to end of a string
ws.Range("D5") = ws.Range("B5") & ws.Range("C5")

End Sub

Hard coded against range of cells
Sub Insert_full_stop_to_end_cell()
'declare variables
Dim ws As Worksheet
Set ws = Worksheets("Analysis")

'insert a full stop to end of a string
For x = 5 To 8

ws.Range("C" & x) = ws.Range("B" & x) & "."

Next x

End Sub

Cell reference against range of cells
Sub Insert_full_stop_to_end_cell()
'declare variables
Dim ws As Worksheet
Set ws = Worksheets("Analysis")

'insert a full stop 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 TOPICS

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
Add value to beginning of a cell How to concatenate a value to the beginning 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