| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parsing Information from a Cell
I have a long list of supplies in Column A. In Column B it shows the range of
their cost ... for example, "79.99 - 89.99". I would like Column C to only include the low end (79.99) of the cost and Column D to show only the upper end (89.99). Is their a formula I can type in Columns C & D to extract this information from Colume B? Each item in Column B is formatted the same way .... the low price followed by " - " then the upper price. Thanks! -- Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing text in a cell | Excel Discussion (Misc queries) | |||
| parsing name in cell by comma? | Excel Worksheet Functions | |||
| Parsing Cell Contents | Excel Discussion (Misc queries) | |||
| Parsing information | Excel Discussion (Misc queries) | |||
| parsing a cell using | | Excel Worksheet Functions | |||
Threaded Mode
