Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
Try with this:
=Replace(Capitalize(Replace(field, chr(39), '_')), '_', chr(39))
Regards,
Ricardo
Hi
Try with this:
=Replace(Capitalize(Replace(field, chr(39), '_')), '_', chr(39))
Regards,
Ricardo
Thank you.