Hi There

I need to know how to make the first letter of the 1st word that I input to be capitalized.

I feel as I should know the answer to this but my mind is blank.

Hope someone can help.

Thanks

Use the Proper() function?

Hi thanks for that.

That gives me the uppercase for all words.

e.g. The Quick Brown

I need: The quick brown

Thanks

Sorry, I missed that part. What should the result be if you enter "the quick Fox is an FBI agent"?

Hi there

I just need this to be "The quick fox is an fbi agent"

So just to clarify "T" needs to best in capitals and rest can be lowercase.

Hope I have explained OK.

Try =

Replace ( Lower ( text ) ; 1 ; 1 ; Upper ( Left ( text ; 1 ) ) )

Excellent Thank You....works a treat.

If you wanted it to be "The quick Fox is an FBI agent" (Keeping everything already uppercase, uppercase), you could take out the Lower ( ).

And, you can use Trim ( ) on the text so the calc doesn't upper case a space (which would mean it would do nothing).

So in the end the calc would be like:

Replace ( Trim ( text ) ; 1 ; 1 ; Upper ( Left ( text ; 1 ) ) )

Automatic message

This topic has been moved from "Database Schema & Business Logic → Custom Functions" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".