Changing text from upper to lower case

  • Thread starter Thread starter Andrew S.
  • Start date Start date
A

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.
 
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.
 
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.
 
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
 
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
 
Back
Top