How to capitalize the first letter of a string of words?

[#1]

Good morning,

I am using data from multiple Excel documents.

In several of these words are in lowercase or uppercase, not respect criteria.

As the words I need to be with capital letter.

Example:

Hello WORD = Hello word

Thank you for your prompt response.

Thanks

[SunilChauhan]

Use this

capitalize('Hello WORD')

and if you want through out your field then

Capitalize(FieldName)

hope this helps

[MK_QSL]

=Capitalize('Hello WORD')

[Colin-Albert · Accepted solution]

Capitalize will make the first letter of every word a capital. Capitalize('hello WORLD') = Hello World

If you only want the first letter of the whole text string to be caps, try this

     upper(left(trim(data),1)) & lower(mid(trim(data),2,len(data)))

where data is the field containg the text you wish to change.

If data is "hello WORLD", this will become "Hello world"

[sudeepkm]

you may use UPPER() or LOWER() to make the field values to a particular case.

[#6]

Thank you for your response has been very useful to me