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

[raveepoojari]

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