View Single Post
  #1   Report Post  
bill gras
 
Posts: n/a
Default help with spaces in funtions

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