Changing the format

[izabelatrojanowska]

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?

[alexnajm · Accepted solution]

Have you tried the TitleCase formula?

[nagakavyasri · Accepted solution]

Use Data cleansing tool (or) formula tool:

[Raj · Accepted solution]

@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.