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.

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.