Prev: changin date dd/mm/yy into Month
Next: Office Professional 2007, HEADER
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" <Ken(a)discussions.microsoft.com> 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" <Ken(a)discussions.microsoft.com> 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" <Ken(a)discussions.microsoft.com> 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 Month
Next: Office Professional 2007, HEADER