Which formula will automatically capitalize the first letter of a word?
A ) Proper ✅
B ) Upper case
C ) Capitalize
D ) None of these
Explanation:
Select the cell in which you want to capitalize the first letter of each word. Type the formula =PROPER(A1) in the formula bar, where A1 is the cell reference for the cell containing the text you want to modify.