To Add Prefix (Dr.) using Concatenate function, type =Concatenate(“Dr. Tip: Instead of typing B4, you can type = Move the cursor to cell B4, type &”, PHD. and hit the enter key.Īfter 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).Īdd Prefix in Excel Using Concatenate FunctionĪnother 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 Suffix, place the cursor in Column C, type =B4&”, PHD.” and hit the enter key on the keyboard of your computer. 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. “& > move the cursor to cell A4 and hit the enter key.Īfter 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). Tip: Instead of typing A4 you can type =”Dr. “&A4 and hit the enter key on the keyboard of your computer. To add the Prefix (Dr.), place the cursor at Column B, type =”Dr. 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.
Perhaps the easiest way to add Prefix or Suffix in Excel is to make use of the “&” Operator.
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.
0 kommentar(er)
