One way:

If the string is in cell A1:

=LEN(A1)-LEN(SUBSTITUTE(A1,"/","")) + (LEN(A1)>0)



In article <u1TWo1tVFHA.2424@TK2MSFTNGP10.phx.gbl>,
"Mas" <mas13@hotmail.com> wrote:

> Hi all,
>
> I would like to calculate the number of pieces if it was seperated by a '/'
> symbol.
>
> i.e. 999999/88 equals two pieces
> i.e. 999999 equals one piece
> i.e. 999999/88/77 equals three pieces
>
> Thank you in advanced.