Text
Smart Title Case
Title case that knows names: O'Neil, McDonald and hyphenated parts come out right, small words like of and van stay lower case, and the acronyms you list stay upper case.
When to use it
Use it instead of Change Case's Title Case for people's names, company names and addresses, where "o'neil mcdONALD" must become "O'Neil McDonald".
In a pipeline
File InputSmart Title CaseExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Keep lower case (after the first word) | text | — | a, an, and, at, by, de, del, der, for, in, la, le, of, on, or, the, to, van, von |
| Keep upper case | text | — | e.g. USA, IBM, LLC |
| Generate New Column | checkbox | — | false |
| New Column Name | text | — | Default: <column> Title |
| Insert After | select | — | After the column |
Example
Names and companies
- Column=Name
- Keep upper case=IBM, LLC
| Name |
|---|
| o'neil mcdONALD |
| ludwig van beethoven |
| ibm consulting llc |
| Name |
|---|
| O'Neil McDonald |
| Ludwig van Beethoven |
| IBM Consulting LLC |
Worth knowing
- The first word is always capitalised, even when it is a small word.
- Contractions and possessives stay right: don't → Don't, mcdonald's → McDonald's.
- The column is rewritten in place by default, like Change Case; tick Generate New Column to keep the original.