excel converting text

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 - converting text into Upper / Lower case | Excel forum

Excel - converting text into Upper / Lower case | Excel forum

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

Working with 3D formulas

You can only use fill-down if you remove $ for Absolute References.

View all Excel hints and tips


Server loaded in 0.08 secs.