All Collections
Formatting Essentials
Capitalizing the First Letter of a Word
Capitalizing the First Letter of a Word

How make the first letter uppercase using Excel's Replace formula.

Eszter Takacs avatar
Written by Eszter Takacs
Updated over a week ago

Using a Formula field, Woodpecker will automatically convert text to all uppercase for designated instances of a word or phrase.

Let's say, for example, you want the first letter of the word Client to be capitalized when the word is used at the beginning of a sentence.

To do this:
1) Create a Single Line Text field for Client

2) Assign that field to the instance(s) in the document where Client should only have the first letter capitalized.

3) Create a Formula field for Client (first letter cap).

4) Choose Field Type: Formula

5) Click in the Formula box to bring up your list of Clauses, Fields, and Functions, in that order.
6) Scroll to the bottom of the list, find and select the Replace( ) function.

7) Position your cursor between the parentheses.

8) Scroll through your list of Clauses, Fields, and Functions again and click on the Client field.

Inserted inside the parentheses in both places in the formula with a set of curly braces like this: REPLACE({Client}),1,1,UPPER(LEFT({Client}),1))

8) Click Save.


Did this answer your question?