Excel Cheat Sheet Help

[shortsavage]

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.

[Amazinz]

=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.

[shortsavage]

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.

[e]

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

[shortsavage]

PERFECT!

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

Thanks for your help e.

[Amazinz]

Wow. I had no idea what you were asking. Must have been the egg nog...