Add value to end of a cell

This tutorial shows how to concatenate a value to the end of a cell, using Excel formulas and VBA.

Example: Add value to end of a cell

Add value to end of a cell

METHOD 1. Add value to end of a cell

EXCEL

=B5&" and Butter"
This formula uses the & sign to concatenate a value at the end of a cell. In this example we are adding " and Butter" to the end of the value captured in cell (B5).

METHOD 2. Add value to end of a cell

EXCEL

=CONCATENATE(B5," and Butter")
This formula uses the Excel CONCATENATE function to add a value at the end of a cell. In this example we are adding " and Butter" to the end of the value captured in cell (B5).

METHOD 1. Add value to end of a cell

VBA

Sub Add_value_to_end_of_cell()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
ws.Range("E4") = ws.Range("B5") & " and Butter"

End Sub

ADJUSTABLE PARAMETERS
Output Range: Select the output range by changing the cell reference ("E4") in the VBA code.
Value to add: Select the value to you want to add to the end of a cell by changing " and Butter" in the VBA code.
Cell to add to: Select the that captures the value to which you want to add a value to by changing the cell reference ("B5").
Worksheet Selection: Select the worksheet which captures the value that you want to add a specific value to by changing the Analysis worksheet name in the VBA code. You can also change the name of this object variable, by changing the name 'ws' in the VBA code.

Explanation about how to add value to end of a cell

EXPLANATION

EXPLANATION

This tutorial shows how to concatenate a value to the end of a cell, using Excel formulas and VBA.
This tutorial provides two Excel methods that can be applied to add a value to the end of a cell.

The first method doesn't use any Excel functions, it uses the & sign to concatenate a value to the end of a cell.

The second method uses the Excel CONCATENATE function to add a value to the end of a cell.

The VBA code in this tutorial uses the & sign to add a value to the end of a cell.
FORMULA (using & sing)
=cell&"value"
FORMULA (using CONCATENATE function)
=CONCATENATE(cell,"value")
ARGUMENTS
value: The value that you want to add to the end of a cell.
cell: The cell that captures a value to which you want to add the specific value to the end of it.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to concatenate a value to the beginning of a cell using Excel and VBA
How to add the same number to a range of cells using Excel and VBA
How to subtract the same number from a range of cells using Excel and VBA