Thank you for your swift reply
What would we do , without people like you
Thanks
bill

"Biff" wrote:

Hi!

Try this:

=SUBSTITUTE(MID(F1,FIND("~",SUBSTITUTE(F1,"
","~",LEN(F1)-LEN(SUBSTITUTE(F1," ",""))))+1,255),"k","")*1

This is case sensitive based on the "k". If the "k's" in your cells are
actually in upper case then make the "k" in the formula also upper case.

OR use this slightly longer version where it doesn't matter:

=SUBSTITUTE(MID(F1,FIND("~",SUBSTITUTE(F1,"
","~",LEN(F1)-LEN(SUBSTITUTE(F1," ",""))))+1,255),RIGHT(F1,1),"")*1

Copy down as needed.

Biff

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