I wanted all of the remaining characters after the /. I could have used
RIGHT subtracting the position of the / from the LEN of the string. I chose
to use MID with a character count of 99 because if you use a number of
characters in the MID function greater than the possible number of
characters it doesn't choke, it just returns as many as it can. Same result
as the RIGHT function, less code.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Excel_Learner" wrote in message
...
You are right Bob
we can use this also:
=LEFT(I19,FIND("/",I19,1)-1)/RIGHT(I19, LEN(I19)-LEN(RIGHT(I19, FIND("/",
I19,1))))

it is a bit lenghty. I couldn't understand why did you take 99 in Mid
function. Could you please explain that. thank a lot

"Excel_Learner" wrote:

You can use this formula:
=LEFT(J51, FIND("/", J51, 1)-1)/RIGHT(J51, FIND("/", J51, 1))

"Bob Phillips" wrote:

=LEFT(D5,FIND("/",D5)-1)/MID(D5,FIND("/",D5)+1,99)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Shazza" wrote in message
...
hi I work with Excel 2000. I have a spreadsheet that holds the pass
marks
for students displayed like so
27-Apr-07 El Health & Safety 13 93/130 72%
29-May-07 First Aid 18 124/180 69%
08-Jun-07 Geography 19 156/190 82%
this shows date, name of course, how many students sat the exam, what
their
pass mark was and then the pass mark as a persentage.
The person who set up this spreadsheet obviously has better math
skills
than
me as she was just typint in the pass mark persentage.

I need to know if there is a formula that will automatically show me
what
the persentage rate is. (my fingers are crossed in the hope that
there
is)
Thank you for reading my post. Hopefully you can answer my querie