Discussion Locked

Changing Case in Excel 2000

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have non-data in a column which is a mixture of upper and lower case charaacters. Is there a simple and quick way of changing all of these either to upper, lower, or title case similar to Word?

4 replies

by dcrish

You can use these three functions:
=lower or =upper or =proper

Place the fomulas in a blank column. When you've copied the formula down, you may want to delete the original column. But so that the formula is no longer connected with that firstcolumn, you will need to do a Copy/Paste Special over the same column.

That is, you'll copy the column with the formula. Then, in the same columns, choose Paste Special command. Then choose Values from that dialog box.

write me if this isnot clear. moorech@cofc.edu

by khinton

try this
UPPER(text)

Text is the text you want converted to uppercase. Text can be a reference or text string.

Examples

UPPER("total") equals "TOTAL"

If E5 contains "yield", then:

UPPER(E5) equals "YIELD"

This discussion is closed to new replies.