In Excel, how to make all caps to sentence case?

Anonymous
2025-03-16T03:19:39+00:00

How to make "ALL CAPITAL SENTENCE" to "All capital sentence" and NOT "All Capital Sentence"

Microsoft 365 and Office | Excel | For education | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Anonymous
    2025-03-16T03:59:26+00:00

    =UPPER(LEFT(A1,1)) & MID(LOWER(A1),2,LEN(A1)-1)

    0 comments No comments
  2. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2025-03-16T23:15:06+00:00

    Hi,

    In cell B2, enter this formula

    =REGEXREPLACE(A2,"^([A-Z])([A-Z]*)(.*)","\U\1\L\2\L\3")

    Hope this helps.

    0 comments No comments