Identify first two letters in a name

[Hotelman12]

Hello, I need some help. In column A I have a set of usernames (ex. SLHOTELMAN) I need a macro to look at the first two letters in the username and find what division he belongs to and return that value to column B.

Column A
SLHOTELMAN
BOMOTELMAN

Column B
SL = Salt Lake
BO = Boise

let me know if I make since at all!!! Thanks for your help

 

[lenze]

Use a VLOOKUP table

Formula in column B would be
=VLOOKUP(A1,YourTable,2, False)

lenze

 

[Scott Huish]

=VLOOKUP(LEFT(A1,2),YourTable,2,0)