Changing text from upper to lower case

[Andrew S.]

Is there an easy way to change text that is in all
uppercase to lower case or just the first letter.

Thanks in advance.

ANDREW s.

 

[Frank Kabel]

Hi
if your data is in column A enter the following in B1
=UPPER(A1)
and copy down

 

[Guest]

I don't quite follow you on how to do it and will this
change the first letter of each word to Uppercase.

Thanks in advance

Andrew S.

 

[Ken Wright]

What Frank has given you is a solution that requires the temporary use of a
helper column. You put the formula in the helper column and copy it down as far
as your data goes in Col A. When done, simply copy Col B and paste over Col A
using Edit / Paste Special as values. Then just delete Col B.

 

[mudraker]

To change your upper case text as requested in a helper column past
this formula in a cell then copy down, Copy column then paste special
value


ABCDEF becomes Abcdef

=UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1)-1))



UPPER(LEFT(A1,1)) gives 1st letter as uppercase
LEN(A1)-1) gives legth of text entry in cell - 1
LOWER(MID(A1,2,LEN(A1)-1)) converts all letters to lowcase after th
1st lette

 

[Gord Dibben]

Andrew

UPPER will change every letter to Uppercase.

PROPER will change the first letter of each word to Upper case.

For usage of these functions read Ken's post.

Gord Dibben Excel MVP

 

[David McRitchie]

If you plan on doing this with some frequency (and I can't imagine
not doing it frequently,) you would be much better of using a macro
to change the data in place for a selection. No helper column and
no messy cleanup.
http://www.mvps.org/dmcritchie/excel/proper.htm