Hi Curalice,

You can use the

Code:

LEFT

function in Excel to extract the first three digits of a number. Here's how you can do it:

1. Select the cell in Column B where you want to display the first three digits of the number in Column A.
2. Type the following formula:
   Code:

   =LEFT(A1,3)

3. Press Enter.

This formula will extract the first three digits of the number in cell A1 and display it in the cell where you typed the formula. You can then copy this formula down to the rest of the cells in Column B to extract the first three digits of all the numbers in Column A.