SelectAdd Suffix. In theSuffixwindow, type,PHDand pressOK. See the prefix has been added to our table. Go toHometab, fromClose & Loaddrop-down menu, and selectClose & Load To. In theImport Datawindow, chooseExisting worksheetand select the cell reference to import data. PressOKto exit. ...
Name:Classandperiod:Date:Prefix-SuffixPractice(1)Word Prefix/Suffix MeaningDirections:Useyourprefix-suffixlisttomakingmeaningofthefollowingwords.(1)Underlinetheprefix,CircletheSuffix.(2)Writeoutthemeaningofeachword.*TheremaynotalwaysbeaprefixANDasuffix!Example:THERMOMETER–thermmeansheat&metermeansmeasureofsoa...
ClickOK. SelectC5:C14andCopythe data by pressingCtrl + C. SelectD5and right-click.Pastethe copied data asValues. This is the output. Read More:How to Add Suffix Without Formula in Excel Download Practice Workbook Download the practice workbook. Text Prefix with Custom Format.xlsm Related Arti...
Select cellD5and enter the following formula: =CONCATENATE(B5," ",C5) PressTaborEnter. It will return the expected result,Edmund Phelps. Use theFill Handletool for the remaining cells. The result will be as shown below. Read More:How to Add Suffix in Excel Method 2 – Use the Ampersand...