Hi,

You may use Data Text to columns. Give the delimited as space and check
the box for other (in the small box, type -


"Ken" wrote in message
...
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