| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I remove empty spaces trailing a text string? | Excel Worksheet Functions | |||
| How do you remove excess spaces from an Excel field? | Excel Discussion (Misc queries) | |||
| Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions | |||
| remove spaces in text in excel | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Threaded Mode
