Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any part of the string that is not required to be in capital? Can you give some more examples to clarify that?
Capitalize should work here.
Capitalize(Column name)
Try:
=Left(Field,FindOneOf(Field, '.&'))&Capitalize( Mid(Field,FindOneOf(Field, '.&')+1))