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

excel converting text

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - converting text into Upper / Lower case

Excel - converting text into Upper / Lower case

ResolvedVersion 2003

Shaun has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Intro Intermediate course

Excel - converting text into Upper / Lower case

How can i convert some text into either upper or lower case?

RE: Excel - converting text into Upper / Lower case

I don't think this can be done in Excel as easily as in Word. Will check in with my collegues to see if they know of a way.

RE: Excel - converting text into Upper / Lower case

Hello Shaun

Thank you for your post.

You can change case in Excel using functions.

This is described on the following page, with examples:
http://support.microsoft.com/kb/263580

I hope this is useful to you.
Amanda

RE: Excel - converting text into Upper / Lower case

Thats great thanks for your help Amanda.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

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.12 secs.