• 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, where an ordinal is an adjective used to describe the numerical position of an object. In Figure 15.10, B7 contains the number 1. If your list of numbers begin in cell B7, the formula would be

Figure 15.10. You can add ordinals to the end of numbers automatically.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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