splitting of value

[cksrules]

Hi, I want to split "108/24/21" present in 1 cell to 108,24,21 in three different cells. Please Help

[martindwilson]

ust data/text to columns with / as delimiter

[cksrules]

ust data/text to columns with / as delimiter

Can you please explain it in detail. Also i wanted it in formulas so that if some enter the value, it will be split-ted automatically.

[martindwilson]

http://office.microsoft.com/en-us/ex...001149851.aspx
as for formula
if a1=108/24/21 then in
b1=TRIM(LEFT(SUBSTITUTE($A1,"/",REPT(" ",50)),20))
c1=TRIM(MID(SUBSTITUTE($A1,"/",REPT(" ",50)),50,50)) d1=TRIM(RIGHT(SUBSTITUTE($A1,"/",REPT(" ",50)),20))