Hi!

Let me see if I can find the original post. I'll get back to you.

Biff

"bill gras" wrote in message
...
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