| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove text from cell containing numbers
How can i remove the text from a cell to leave the mumbers? I can remove it when there is only one block, IE 16m to read 16 But what about 16m 30s to read 16.30? or even better as the above means 16minutes 30seconds i would love it to read 16.50 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| extract numbers from cell containing text & numbers | Excel Worksheet Functions | |||
| How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
| Function to remove a space from text in cell WITHOUT macro?? | Excel Worksheet Functions | |||
| Sum cell numbers that have certain text within the cell | Excel Worksheet Functions | |||
Threaded Mode
