| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extract numbers from strings
Hi All!
How do I extract a number from a string? Example: cell D64 has a string "Q30 no lockup" in my case, the first char is always a letter and the next two chars form a number I need to extract. When I try =N(right(left(D64,3),2)) it returns 0 I need 30. I need ultimately to find the average of these numbers in the strings running across. Help? THANKS! Stan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Threaded Mode
