/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

1 vote149 views2 answers
Vba find last row in range for certain criteria
VBA
1 vote177 views1 answer
Extract the second word in a text in excel
VBA
0 vote161 views1 answer
Add text to combobox drop down vb
VBA
0 vote158 views1 answer
Vba type
VBA
0 vote182 views1 answer
Create new worksheet excel visual basic
VBA
0 vote189 views1 answer
Amd64 vs arm64 linux
VBA
0 vote157 views1 answer
Dynamic array vba
VBA
22 votes287 views1 answer
Xlvba check for folder
VBA
0 vote168 views1 answer
Thread sleep vb
VBA
0 vote203 views1 answer
Vba excel do not recalculate before save
VBA