i hav a problem.......i have an excel sheet which hav the B column values as
B1=ant & boy
B2=cat & doll etc.....
i need to split these values and paste them in C & D columns in same row.....like i will have
C1= ant, D1=boy
C2=cat, D2=doll......ho wto achieve this??it may b simple.....but am having problems......any help??