Mon 26 Feb 2007, 11:41Delegate Sohail said...
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
Mon 26 Feb 2007, 14:37
Edited on Mon 26 Feb 2007, 16:35Trainer Tracy said...
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
