Changing the format

Question

Hi! I have the value ARCHIE FREEMAN and would like to change it to Archie Freeman, just like the same as in the output file. Could you please help?

3.yxmd

output4.xlsx

alexnajm · Accepted Answer

Have you tried the TitleCase formula?

nagakavyasri · Accepted Answer

Use Data cleansing tool (or) formula tool:

Raj · Accepted Answer

@izabelatrojanowska 
you can achieve this by Data cleansing tool and Formula too
but i will suggest you to go with formula tool which is a better option for large dataset

TitleCase([Field])

hope this helps
mark done if solved.