What i am actually trying to do is to extract numbers and texts in different cells e.g A1 contains <LGGACC=29720KG; LGGLOS=56105KG; LGGADD=4356KG> and want to get <LGGACC>, <LGGLOS> & <LGGADD> in cell B1,B2 & B3 respectively; while, <29720>, <56105> & <4356>in cell C1, C2 and C3 respectively.

i will be happy if it is formula than VBA