Adding Text Using Functions

• 1). Add two additional columns to the right of the column to which you want to add the apostrophes. Assuming your original column of data is in column A, click on the "A" at the top of the column (to select the entire column "A") and then click the insert button twice to create an empty "B" and "C" column.
  
  
• 2). Select the blank cell to the right of the first cell you want to modify. If you want to modify "A1," select cell "B1" by clicking in it.
  
  
• 3). Click the insert function button or press the equal key (=) to begin a new function. From the list of functions, choose "Concatenate." A "Function Arguments" dialog box will appear with fields for Text 1 and Text 2.
  
  
• 4). Enter an apostrophe in the "Text1" box. Click in the "Text2" field. Enter "A1" (without quotation marks) into the Text2 field or click once on cell "A1" in the spreadsheet.
  
  
• 5). Insert another apostrophe into the "Text3" field and click the "OK" button to complete your formula. Cell "B1" should now contain a formula that looks like the data in cell "A1" surrounded by apostrophes.