Extracting the First Two Numbers of an Employee Number in Excel

To extract the first two numbers of an employee number in Excel, follow these steps:

1. Select the cell in column B where you want to display the first two numbers of the employee number.
2. Type the following formula into the formula bar:
   Formula:

   =LEFT(A1,2) 

3. Press Enter on your keyboard.

The formula uses the LEFT function to extract the first two characters from the cell in column A where the employee number is located. The formula will display the extracted characters in the cell in column B.

Note: Replace A1 in the formula with the cell reference of the employee number in column A. Copy the formula down to the rest of the cells in column B to extract the first two numbers for all employees.