In this video tutorial we will look at two methods for capitalising the first character of each word within a cell.
Method 1: Flash Fill
To use Flash Fill to capitalise the first letter of each word in a column:
- In a cell adjacent to the cell containing your text, type that text with capitalised first characters. For example, tom smith as Tom Smith.
- Use CTRL ENTER to confirm the entry and then CTRL E to Flash Fill.
Method 2: The PROPER Function
To use the PROPER function to capitalise the first letter of each word in a column:
- In a cell adjacent to the cell containing your text, type the following formula =PROPER(A2) – swapping A2 for the cell address containing your text.
- Copy the formula down the remainder of the column.
The advantage of using the PROPER function is that it will update if the original text is updated, whereas Flash Fill will not update.