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
|