CODEWITHSUNDEEP
excelexcel-formula
Jagadeesh Urlana
Jagadeesh Urlana

Reputation: 87

How to automatically upper case first letter in all words in MS Excel sheet with a function or formula

I have a requirement to make first letter as upper case in all the words in my excel sheet. Is there any function to make this change automatically rather than changing all the content manually.

Upvotes: 0

Views: 3218

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

Use Proper() function.

=PROPER(A1)

enter image description here

Or if you want only the first character of cell would be upper case and rest of the words will be lower then use.

=UPPER(LEFT(A2,1)) & LOWER(RIGHT(A2,LEN(A2)-1))

enter image description here

Upvotes: 2

Related Questions