The formula you gave me =substitute(mid(f1,find("~",substitute(f1,"
","~",len(f1)-len(substitute(f1," ",""))))+1,255),right(f1,1),"")*1 works
partley,it will only give me the first 3 rows with a result and the other 297
rows have a #value! result
could you please help me I have tried to change parts of the formula but no
luck

thank you
--
bill gras