The original post:

************************************
I have in cell F1 open 4+ 60k
in F2 c6 50k
in F3 c4 522.5k I need the last part of each cell
without the "K'

eg: F1 open 4+ 60k = open(space)4+(space space)60k result 60
F2 c6 50k = c6(space space)50k
result 50
F3 c4 522.5k = c4(space)522.5k
result 522.5
The list goes down to 300 rows
I have tried some find functions but can not get the correct result for each
row

hope some one can help

************************************

Ok, can you post some more examples of the data from the cells where you're
getting the error?

Biff

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