ExcelBanter - How do I format minuscule word in capital letter one in excell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format minuscule word in capital letter one in excell? (https://www.excelbanter.com/excel-discussion-misc-queries/113887-how-do-i-format-minuscule-word-capital-letter-one-excell.html)

Renato Silvio

How do I format minuscule word in capital letter one in excell?

How do I format minuscule word in capital letter one in excell?

Kevin B

How do I format minuscule word in capital letter one in excell?

=Proper(Text)

So if the value is in cell A1 in cell B1 enterthe formula =Proper(A1) and it
will uppercase the first letter of each word.
--
Kevin Backmann

"Renato Silvio" wrote:

How do I format minuscule word in capital letter one in excell?

All times are GMT +1. The time now is 10:42 AM.