=LEFT(A1,3)

How i learned the majority of what i know of formulas was from hitting the
function button and reading the descriptions on all of the functions
available and trying the ones i liked. Other than that reading through here
for interesting requests and finding how they were solved goes a long way.
I'm sure there are plenty of books but i've never used them so can't
recommend any.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"cware" wrote:

In my column of info I have ie....

abc
abc
abc01
trx
trx1
gaf
gaf2

What I need to do, is grab only the first three characters that are always
alpha, and remove all numbers.

Secondly, where do I go, to get real education on the formulas? I love
working with excel and my employer loves what I'm doing, but I need to go to
the next step.

Thanks!!