Cell references in Excel are like addresses that point to specific cells. Three types of Excel cell references are relative, absolute, and mixed, each with unique functions.

Step 1: First, you'll use the formula =LEFT (A2,SEARCH (” “,A2)-1) in cell B2 in this example to pull out the first name. Replace the cell reference as required in your spreadsheet.