how can i get only first two digits of mentioned cell Values?

dear friends,



now i am faceing new problem. i have attachmed excel file. in that file total 8 colums among them i kept 8th colum empty .

but i want name racks in that file. i knw..it will confuses u. but once u see my attachemts u will realize.

eg: if G2 =XA06-G-001 I2 will be XA only..(XA is rack Name)
if G2 =XB06-G-001 I2 will be XB only
if G2 =XC06-G-001 I2 will be XC only
if G2 =XD06-G-001 I2 will be XD only

i mean to say..i want only first two alpabatics of G2 in I2..

please help me

Put this in I2, then copy it down:

=LEFT(G2,2)

To remove the formulas and leave the answers, highlight column I and copy it, then select EDIT > PASTE SPECIAL > VALUES.

Thank You...very much...ur simply great..