From: Ken on 5 Mar 2010 11:11 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 From: Don Guillett on 5 Mar 2010 11:18 Look in the help index for FIND and then look for LEFT, RIGHT, MID -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Ken" wrote in message news:E4048BD7-0B3B-4C11-BFA5-2562EC9DBF1C(a)microsoft.com...>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 From: Fred Smith on 5 Mar 2010 11:35 The formula in C would be: =--LEFT(B1,FIND("-",B1)-1) In D; =--MID(B1,FIND("-",B1)+1,99) Another option is to use Text-to-Columns with the dash (-) as the delimiter. Regards, Fred "Ken" wrote in message news:E4048BD7-0B3B-4C11-BFA5-2562EC9DBF1C(a)microsoft.com...>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 From: Ashish Mathur on 12 Mar 2010 11:06 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 news:E4048BD7-0B3B-4C11-BFA5-2562EC9DBF1C(a)microsoft.com...> 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  |  Pages: 1 Prev: changin date dd/mm/yy into MonthNext: Office Professional 2007, HEADER