How to capitalize the first letter in a text string in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 325
Joined: Tue Sep 25, 2007 12:41 pm

How to capitalize the first letter in a text string in Excel

Post by Admin »

Excel has a function that capitalizes the first letter in each word:

=PROPER(text)



Let's see the following example. Enter in cell B1

=PROPER(A1)


Image


You may copy it down the column for the rest text strings.
Post Reply