IF number/text in a cell begins with specific letter, then return desired word

Hi,

I have a column of reference numbers which will either begin with the letter L, Q, or a numeric value. I want a cell in the adjacent column to return a word based on whether it begins with an L,Q or number. For example, if:

Cell A1 = L123. Then B1 would show ABC
Cell A2 = Q123. B2 would show XYZ
Cell A3 = 2013. B3 would show 123.
Cell A4 = L124. Then ABC.

Etc Etc.

I use the below formula to take into account two criteria for the formula (letter or numeric):
=IF(G2="","",IF(ISNUMBER(LEFT(G2)+0),"123","ABC"))

But am a bit clueless of how to take it a step further.

Any help greatly appreciated.

Try this:

=IF(G2="","",IF(ISNUMBER(LEFT(G2)+0),"123",if(Left(G2,1)= "L","ABC", "XYZ")))