• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Text Functions > Add st, nd, rd, and th to the End of Numbers

Add st, nd, rd, and th to the End of Numbers

You can use the IF, OR, VALUE, RIGHT, and CHOOSE functions together to create automated ordinals. In Figure 15.10, B7 contains the number 1. If your list of numbers begin in cell B7, the formula would be

=B7&If(Or(Value(Right(B7,2))={11,12,13} ),"th",If(Or(Value(Right(B7)) ={1,2,3} ),Choose(Right(B7),"st","nd","rd"),"th"))


					  


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint