Capitalize

[Anonymous]

I'm using Capitalize(), it works fine for normal text but if there's a value like:

adam's

it converts it to:

Adam'S

I want:

Adam's

Any suggestions?

[#2 · Accepted solution]

Hi

Try with this:

=Replace(Capitalize(Replace(field, chr(39), '_')), '_', chr(39))

Regards,

Ricardo

[Anonymous]

Thank you.