| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
parsing number ranges
I need to parse cells in a spreadsheet, that contain strings such as "4-6" or "12-37" or "40-46", that represent ranges of numbers, in order to find numbers contained in those ranges. For example, the desired output for "4-6" would be "4,5,6". Find and replace is not a suitable tool because I can't predict what strings will be found. -- chchch ------------------------------------------------------------------------ chchch's Profile: http://www.excelforum.com/member.php...o&userid=31970 View this thread: http://www.excelforum.com/showthread...hreadid=517783 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Problem with graph ranges | Charts and Charting in Excel | |||
Threaded Mode
