If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Parsing Information from a Cell
Look in the help index for FIND and then look for LEFT, RIGHT, MID
-- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#3
|
|||
|
|||
Parsing Information from a Cell
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 ... 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 |
#4
|
|||
|
|||
Parsing Information from a Cell
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 |
Thread Tools | |
Display Modes | |
|
|