Sat, 21 Apr 2007 07:48:01 -0700 from Rob
:
I have 26,000 cells that I need to extract just the first 3 digits of the
cell. For example, the cell reads AAG122345 and I need a new cell that only
reads "AAG". How can I do this?

Assuming those cells are in A1 through A26000, put this in B1:
=left(A1,3)
then click and drag that formula to the other 25999 cells in column
B.