excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2007

Kathryn has attended:
Excel Introduction course
Excel Intermediate course

Excel

how can you change words from capitals to lower case in a spreadsheet?

RE: excel

Hello Kathryn,

To change from Lower to capital case in Excel, use the function word Lower(). There is no ChangeCase option from the Ribbon bar that Word 2007 has.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: excel

Hi Kathryn, this link http://www.theexceladdict.com/_t/t031112.htm
explains the process Mark says about above, it also has some more Excel help.

Baz


 

Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips


Server loaded in 0.09 secs.