Hi Paul, thank you missing /2 .... now the formula workable
thank for your excellent knowledge

=(LEN(B2)-LEN(SUBSTITUTE(B2,"1w","")))/2*1+(LEN(B2)-LEN(SUBSTITUTE(B2,"2w","")))/2*2+(LEN(B2)-LEN(SUBSTITUTE(B2,"3w","")))/2*3+(LEN(B2)-LEN(SUBSTITUTE(B2,"4w","")))/2*4+(LEN(B2)-LEN(SUBSTITUTE(B2,"5w","")))/2*5+(LEN(B2)-LEN(SUBSTITUTE(B2,"6w","")))*/2*6+(LEN(B2)-LEN(SUBSTITUTE(B2,"7w","")))/2*7+(LEN(B2)-LEN(SUBSTITUTE(B2,"8w","")))/2*8