• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office

How to Add Prefix or Suffix in Excel

By: Waseem Patwegar

Sometimes you may come across the need to add a common text at the beginning or end of all the cells in an Excel spreadsheet. Instead of doing this one cell at a time, you can quickly add Prefix or Suffix in Excel by using steps as described below.

Add Prefix or Suffix in Excel

Add Prefix or Suffix in Excel

As mentioned above, manually adding a common Prefix or Suffix to all the cells or a group of cells in Microsoft Excel can be time consuming.

If you are dealing with a large spreadsheet, the act of adding Suffix or Prefix to each and every cell of an Excel spreadsheet can take a very long time and leave you frustrated and tired.

Hence, we are providing below the steps to quickly add Suffix or Prefix in Excel spreadsheet using “&” Operator and Concatenate Function as available in Microsoft Excel.

Add Prefix in Excel Using “&” Operator

Perhaps the easiest way to add Prefix or Suffix in Excel is to make use of the “&” Operator.

In order to explain this better, let us assume that you have an Excel spreadsheet containing names of doctors in Column A and the task is to add the Prefix “Dr.” to each and every name in Column A.

Add Prefix in Excel Using "&" Operator

To add the Prefix (Dr.), place the cursor at Column B, type =”Dr. “&A4 and hit the enter key on the keyboard of your computer.

Tip: Instead of typing A4 you can type =”Dr. “& > move the cursor to cell A4 and hit the enter key.

After adding the Prefix (Dr.) to the first cell, you can quickly Add Prefix to all the cells by dragging the formula down to all the cells in column B (See image below).

Add Prefix to Group of Cells in Excel Using "&" Operator

Add Suffix in Excel Using “&” Operator

In this case, let us assume that you are required to Add the Suffix “PHD.” to all the cells in Column B, so that names read in the format Dr. Name, PHD.

Add Suffix in Excel Using “&” Operator

To add Suffix, place the cursor in Column C, type =B4&”, PHD.” and hit the enter key on the keyboard of your computer.

Tip: Instead of typing B4, you can type = Move the cursor to cell B4, type &”, PHD. and hit the enter key.

After adding the suffix (PHD.) to the first cell, you can quickly add this common Suffix to all the other Cells by dragging the formula down to all the Cells in column C (See image below).

Add Suffix to Group of Cells in Excel Using “&” Operator

Add Prefix in Excel Using Concatenate Function

Another way to Add Prefix or Suffix to a group of Cells in Excel is to make use of the “Concatenate” function as available in Microsoft Excel.

To Add Prefix (Dr.) using Concatenate function, type =Concatenate(“Dr. “,A4) and hit the enter key on the keyboard of your computer.

Add Prefix in Excel Using Concatenate Function

Tip: Instead of typing A4 in above formula, you can move the cursor to A4 cell

Once Prefix is added to the first cell, you can quickly add this common Prefix to all the remaining Cells in the Excel spreadsheet by dragging the formula to all the remaining cells.

Add Suffix in Excel Using Concatenate Function

Again using the above example, let us add the Suffix “PHD.” to the end of all the names in Column B using Concatenate function.

To do this, place the cursor in Column C and type =Concatenate(B4,” PHD.”) and hit the enter key on the keyboard of your computer.

Add Suffix in Excel Using Concatenate Function

After adding the Suffix in the first cell, you can quickly add the Suffix to all the remaining cells by dragging the formula to all the remaining cells.

Related
  • How to Create Pivot Tables in Excel
  • How to Use VLOOKUP Function in Excel

Primary Sidebar

Twitter
Facebook

Popular Now

  • How to Boot Windows 10 From USB Drive
  • How to Backup iPhone to iCloud
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Setup Chromecast on Android and iPhone

Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks



About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2021 @Techbout.com · All Rights Reserved