Spelling/mixed casing

Hi Liz

Thank you for your question. There are three Excel functions that can help:

UPPER()

LOWER()

PROPER()

They return uppercase, lowercase or Title Case results. Just create a formula using the relevant function eg =PROPER(A1) Turns text in A1 to Title Case (words with capital initials)
or LOWER("SOME TEXT") would produce the result:

some text

Beyond that we would need to create a macro to make changes (e.g. capitalise the first word of every sentence)

I hope this helps.

Kind regards,
Andrew