Suffix and Prefix in Excel
Aug 13, 2024
This is an overview:
Example 1 - Add a Designation Prefix
Steps:
Select D5:D14.
Press Ctrl+1.
In the Format Cells window, go ...
Jul 6, 2024
Method 1 - Apply CONCATENATE Function to Add Prefix in Excel
Concatenate is defined as joining or combining. The CONCATENATE function connects text ...
May 26, 2024
How to Add Suffix in Excel: 4 Easy Ways
Our sample dataset has three columns labeled Name, Suffix, and Email.
Method 1 - Utilize CONCATENATE ...
Nov 11, 2025
There are many ways to add suffix in Excel. Out of those many ways, we will show you 2 easy ways to add suffixes in Excel without a formula. Isn't it ...
Aug 12, 2024
Example 1 - Adding a Text Suffix (e.g. Kg) for Mass
The dataset below showcases multiple weight values. There is no unit.
To add “Kg” as suffix ...
Jul 1, 2024
Column B has a list of phone numbers that begin with 91. We'll remove the prefix.
Method 1 - Using the REPLACE Function to Remove Prefix ...
Nov 11, 2025
Sometimes, we have a dataset in Excel and we may want to add a common prefix to all the data. We can do that quite simply in Excel without even using ...
May 21, 2024
The following sample dataset shows some student IDs that start with ID and the Name of the corresponding IDs in Column C and Column B respectively.
...
