Thread: Excel Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rharper9653 rharper9653 is offline
external usenet poster
 
Posts: 1
Default 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