Thread: Need formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default Need formula

Hello, I am looking for a formula that will allow me to take specific figures
from a cell before and after a "/".

Example: 3/12
So in one cell I need it to read 3 and in another cell I need it to read 12.

This has to be done with formula and not macro. Any thoughts?

Thanks.