| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find % number from text string
I am trying to come up with a formula to display a percentage in
another cell from a long string of other random text and if none to show up at 0%. For example, the string in C1 is "(10%, 1, 15hr) blah blah blah" i need a cell that finds the 10 and displays 10% and if there is no % to display 0%. can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup or find matching number in text string | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| find last number in a string? | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
| find position of a number in a string | Excel Worksheet Functions | |||
Threaded Mode
