Combining small and Caps in table

[#1]

Hi All,

I have two similar values AAA & aaa. I want it to be displayed as aaa. can it be done by expression in the table?

Thanks,

Sai.

[#2]

Capitalize worked.

[morganaaron · Accepted solution]

Capitalize should show AAA or aaa as Aaa - if you want it all lower, you can use the Lower() function, similarly the Upper() function will stick it all in caps.

[ThornOfCrowns]

Please mark morganaaron's answer as correct, not your own response.