in a field i have a data like this APPLE:PHONES:NEW:iPad 16GB 3G White
i need seperate them like APPLE in next cell PHONES NEW next cell ipad 16gb 3g white. basically i need to seperate all before or after :
for first one i made like left(cell,find(":",cell)-1)
how can i do for all those like that.