Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Excel
microsoft-excel-courses - Excel
Resolved · Low Priority · Version Standard
Sohail has attended:
Excel Intermediate course
Excel Introduction course
Excel
I wish first letter in "Excel" or in "Words" to be in Capital. How can I set this up?
Thank you,
Sohail
For upcoming training course dates see: Pricing & availability
RE: Excel
You can use a function called =PROPER() this function converts text to capitalise the first letter. WIthin the brackets you must select the cell that contain the text.
=PROPER(text)
This formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
Hope that helps
Tracy
|
