News

To auto-capitalize the first letter in Excel, you can use the formula =UPPER(LEFT(A1,1)) & MID(A1,2,LEN(A1)-1). This converts the first letter to uppercase and keeps the rest of the text unchanged.