Thread: Performing arithmetic functions to cells with number and text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arithmetic functions with embedded text Arithmetic functions with embedded text is offline
external usenet poster
  
Posts: 1
Default Performing arithmetic functions to cells with number and text
I have data entered in one cell in this format: 80/60

and I would like to find the difference of that cell with one of similar
format...75/57

by subtracting 75-80 and 57-60.

How can I do this with the / embedded within the cell.

Perhaps just entering the data with a "," instead would help?
Reply With QuoteReply With Quote