Is this all in one cell: 10999 (212th)

C1 = 10999 (212th)
G1 = 15537

=IF(ISERROR(FIND("(",C1)),0,--SUBSTITUTE(MID(C1,FIND("(",C1)+1,255),RIGHT(C1,3), ""))/G1

Format as %

Result = 1.36%

Biff

"Bob Smith" wrote in message
nk.net...
Hi folks,

I'm pulling down data off a web query from a trivia game site. Data is
listed for 20 + games, each in a row. In one column (c), it will show
where I'm averaging in points earned via 10999 (212th) and in another
column (g), same row, show how many players were playing 15537.

I'd like to set up another column showing what percentile I stand at, by
pulling out the numbers within the ( ), and removing the th or nd or st.
IOW, set up a formula 212/15537 or whatever the updated shows.

Any easy way to pull out the data within the brackets?

TIA,

Bob