How to Add Suffix in Excel (4 Easy Ways)

How to Add Suffix in Excel: 4 Easy Ways

Our sample dataset has three columns labeled Name, Suffix, and Email.

Method 1 – Utilize CONCATENATE Function to Add Suffix in Excel

STEPS:

• Select the D5 cell.
• Input the formula below in cell D5.

• Press Enter.
• It will give the desired output, [email protected].

• Click and drag down the Fill Handle icon till Cell D10 to apply the formula to the other cells.

Method 2 – Use “&” Operator in Excel to Insert Suffix

STEPS:

• Select cell D and add the formula given below.

• Hit the Tab key or the Enter key.
• You will get the output [email protected].

• Click and drag down the Fill Handle icon till Cell D10 to apply the formula to the other cells.

Read More: How to Add Text Suffix with Custom Format in Excel

Method 3 – Attach Suffix with Format Cells Attributes

STEPS:

• Select cell D and add the formula below.

• Hit the Tab or Enter key.
• It will give the output james.

• Click and drag down the Fill Handle icon till Cell D10 to apply the formula to the other cells.

• Select cell D5.
• Hold the Shift key and press the Down Arrow key to select the range from D5 to D10.

• Right-click on the range.
• Choose Format Cells.

• The Format Cells window will pop up.
• Go to Custom.
• Add @”@outlook.com” in the Type Section.
• Hit OK.

• It will add the suffix to the selected range of cells.

Read More: How to Add Suffix Without Formula in Excel

Method 4 – Add Suffix Through Excel VBA

STEPS:

• Choose the active sheet of the worksheet.
• Navigate to Developer.
• Select Visual Basic.

• Click Insert, followed by Module.

• Add the code below into the Module Box.

Sub SOFTEKOaddSuffix()
Dim i As Integer
Dim name
Dim suffix
Dim email
For i = 5 To 10
name = Cells(i, 2).Value
suffix = Cells(i, 3).Value
Cells(i, 4).Value = name & suffix
email = Cells(i, 4).Value
Next
End Sub

• Press F5 or click on the Run button.

• The suffix will be added to the selected cell range.

Download Practice Workbook

Related Articles

• How to Add Prefix Without Formula in Excel
• How to Add Prefix to Entire Column in Excel
• How to Add Text Prefix with Custom Format in Excel
• How to Remove Prefix in Excel
• How to Remove Prefix 91 in Excel

<< Go Back to Suffix and Prefix | Text Formatting | Learn Excel