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

access

ResolvedVersion 2007

David has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Access Advanced course

Access 2007

Can you change selected range of text from lower case/ upper case to upper case/ lower case/ title case

RE: Access 2007

Hi David

Thank you for your post.

There are functions in Excel that allow you to change the case of text in Excel - unfortunately it doesn't work like Word where you can select something and change the case using the Format menu.

Please find below a link to a page that explains how the various functions can be used to change case:
http://support.microsoft.com/kb/263580

Amanda

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.