/VBA/Excel vba get ordinal number from cardinal number

Excel vba get ordinal number from cardinal number

Function Ordinal(n)
  Ordinal = n & Evaluate("IF(OR(--RIGHT(" & n & ",2)={11,12,13}),""th"",IFERROR(CHOOSE(RIGHT(" & n & "),""st"",""nd"",""rd""),""th""))")
End Function

Source: stackoverflow.com

Similar codes

0 vote238 views1 answer
.net crash app
VBA
0 vote259 views1 answer
Excel vba convert cells address
VBA
0 vote224 views1 answer
Vba border weight
VBA
3 votes228 views1 answer
Vba make long from two words
VBA
0 vote226 views1 answer
Vba table header name
VBA
0 vote233 views1 answer
Excel vba combine ranges
VBA
0 vote281 views1 answer
Vba vbcrlf chr
VBA
0 vote221 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote216 views1 answer
Excel vba formatconditions range
VBA
1 vote215 views1 answer
Excel vba last row of range
VBA