access

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

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

Access 2007

resolvedResolved · Medium Priority · Version 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:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips


Server loaded in 0.09 secs.