UPPER, LOWER and PROPER

Standardise inconsistent text case in names and reference fields.

Practical example

=PROPER(A2)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.