On Fri, 30 May 2008 10:37:01 -0700, das wrote:

I have account numbers and the first three numbers determine the location of
the account. What I would like is to have a formula that reads the first
three numbers of the of all the account number and then assign the name of
the account in an adjacent cell.

9895254 would be a "Retail" account
8892532 would be an "Expense" account
etc...

Use the VLOOKUP function, with lookup_value being either LEFT(account_number,3)
or, if the values in your lookup table are numbers, then
--LEFT(account_number,3)
--ron