Subtract 2 numbers from cell with text

[Alphacsulb]

I'm not sure if this is possible but I have a cell with the following:

Sample Ballot Pamphlets / 30.5 of 32 pages /

Is it possible to make a formula that says, look for the 2 numbers in the cell and subtract the 1st number from the second.

Result = 1.5

I know it's a long shot but figured it might be possible.

 

[T. Valko]

This also worked!

Good deal. Thanks for the feedback!

 

[Rick Rothstein]

Just to point out... the UDF that I posted also works (I tested it on the file that the OP made available).

 

[snoopyhr]

I just wanted to see if I could do this very crude but works

Excel Workbook
	A	B
2	Page 1001 of 2000 pages	999
Sheet9

 

[pgc01]

Here is the sample file:

http://www.4shared.com/document/nOYU7LFw/SampleFile.html

I've tried the 3 different methods, and each one works in a new worksheet but not my existing one.

Hi Julia

In your file you have the option "Transition formula evaluation" set. It's usually set by people transitioning from Lotus to Excel.

That explains why the solutions don't work in your file. Try unchecking the option and the solutions should work.

 

[Alphacsulb]

Hi Julia

In your file you have the option "Transition formula evaluation" set. It's usually set by people transitioning from Lotus to Excel.

That explains why the solutions don't work in your file. Try unchecking the option and the solutions should work.

Fantastic! Thanks for your help and feedback.