Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
How do i get the data to the right of slash using a formula
the formula below works for data to the left of the slash thank for any help. Cell A1 - 11.25 / 12.25 =MID($A$1,1,FIND(" / ",$A$1,1)-1) Results = 11.25 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Actually, the formula you are using will only work if the data in cell
A1 is Text, if you use the "=" sign in cell A1 it will not work. If you are sure that the data is TEXT then you can use the formula =Right(A1,6), to get the results at the left. HTH On Apr 26, 4:04*pm, rharper9653 wrote: How do i get the data to the right of slash using a formula the formula below works for data to the left of the slash thank for any help. Cell A1 - 11.25 / 12.25 =MID($A$1,1,FIND(" / ",$A$1,1)-1) *Results = 11.25 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
"rharper9653" wrote:
How do i get the data to the right of slash [....] Cell A1 - 11.25 / 12.25 If you want to assume exactly one space following the slash, as you did for the left-hand number, then one of the following: =RIGHT(A1,LEN(A1)-FIND("/",A1)-1) or =MID(A1,FIND("/",A1)+2,99) Note that 99 is arbitrary, but usually sufficient. I would be inclined to put TRIM around each formula. So: =TRIM(RIGHT(A1,LEN(A1)-FIND("/",A1))) or =TRIM(MID(A1,FIND("/",A1)+1,99)) ----- original message ----- "rharper9653" wrote: How do i get the data to the right of slash using a formula the formula below works for data to the left of the slash thank for any help. Cell A1 - 11.25 / 12.25 =MID($A$1,1,FIND(" / ",$A$1,1)-1) Results = 11.25 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |