## Excel Cheat Sheet Help

Moderator: Baseball Moderators

### Excel Cheat Sheet Help

Hey everyone,

I am doing a highly formula-based cheat sheet on excel this year (you should try one, they are fun).

And I was wondering if anyone could help me out with one thing:

Is there a way to command excel to change ranks to simple numbers?
ex. 22nd --> 22

Let me know if you want any excel help to get your sheet started. I have found lookup functions to be quite helpful in my construction, and I would love to help anyone use them.
Mike Pelfrey > Matt Garza
shortsavage
General Manager

Posts: 2931
(Past Year: -15)
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

=RANK(number, array, order)

number is the number to find the rank for.

array is the range or array of numbers to base the ranking on.

order is optional. 0 = descending order, >0 = ascending order.
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement

Posts: 18680
(Past Year: -120)
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Thanks for the help Amazinz. Maybe I am just not understanding what the rank function does, but I don't think it is what I am looking for.

Hehe, I hardly know how to explain what I am after. It would probably end up being like a page-long essay that wouldn't really make sense. I'll just keep doing this the long way.
Mike Pelfrey > Matt Garza
shortsavage
General Manager

Posts: 2931
(Past Year: -15)
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

highlight the selected cells

Edit/Replace

Find all "nd" Replace with "" (leave replace blank) Replace all
Find all "st" Replace with "" (leave replace blank) Replace all
Find all "rd" Replace with "" (leave replace blank) Replace all
Find all "th" Replace with "" (leave replace blank) Replace all
 e
Little League Legend

Posts: 7
Joined: 29 Feb 2004
Home Cafe: Baseball

PERFECT!

Hehe, actually my girlfriend's dad helped me figure this out this evening.

Mike Pelfrey > Matt Garza
shortsavage
General Manager

Posts: 2931
(Past Year: -15)
Joined: 25 Aug 2003
Home Cafe: Baseball
Location: UC Davis

Wow. I had no idea what you were asking. Must have been the egg nog...
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement

Posts: 18680
(Past Year: -120)
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters