| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i separate numbers and text in a cell?
i have the following text string
"Home: installation on Cognos (5.5 hrs)" the number represents the number of hours i want to have separated from the text" difficulty is the fact this can be displayed as 5.5hr, or 5.5 uur. secondly this doesn't necessary is 3 positions. could also be 5 uur. the only common part is that the data is ALWAYS at the right hand site of the text string |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ascii iinput file - separate text from Numbers | Excel Worksheet Functions | |||
| How to separate the numbers and characters in the cell | Excel Worksheet Functions | |||
| Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
| Separate text within a cell | Excel Discussion (Misc queries) | |||
| How to separate numbers from text?? | Excel Discussion (Misc queries) | |||
Threaded Mode
