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: 286
Joined: Tue Sep 25, 2007 12:41 pm

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

Post by Admin » Mon Mar 13, 2017 8:11 pm

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.






*Recommended:


Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com

Post Reply