Title Case for names and places
Title Case capitalizes the first letter of each word and lowercases the rest, including after hyphens and apostrophes, so “o'neil” becomes “O'Neil” and “mary-jane” becomes “Mary-Jane”. For contact lists, Capitalize person names applies this only to columns such as Name, First Name or Surname and leaves company names and codes alone.
Watch out for acronyms
Title Case also changes acronyms and brand names (“IBM” becomes “Ibm”), so limit it to the columns that need it. Case changes never touch header names; use the header style in the Columns section for those.
Consistent case before matching
Many systems treat “Paris” and “PARIS” as different values. Making a column consistently lowercase or Title Case before you deduplicate, build a pivot table or import avoids split categories and missed matches.