Hi Hussain;
Try in cell C3:
=TRIM(MID(SUBSTITUTE(TRIM($A3)," ",REPT("
",LEN($A3))),((COLUMN(A3)-1)*LEN($A3))+1,LEN($A3)))Copy to other column Wassalam ~ Bagus ~ ----- Original Message ----- From: [email protected] To: [email protected] Sent: Thursday, April 10, 2014 2:32 PM Subject: ]] XL-mania [[ Required Every Digit in Single Column [1 Attachment] Dear Group Members, I need to split down from Column to Every "002262" in Individual Column Regards, Maqbool Hussain
