Sign in with
Sign up | Sign in
Your question

Excel All Caps

Last response: in Windows XP
Share
Anonymous
April 26, 2005 12:44:04 PM

Archived from groups: microsoft.public.windowsxp.basics (More info?)

I have been reformatting spreadsheets that other people have sent me. I have
received some that people have put in all caps. I haven't known how to change
it from all caps to first letter capitalized easily, so I've had to retype
them. Does anyone know if this is possible or if retyping is my only option?

More about : excel caps

Anonymous
April 26, 2005 4:02:45 PM

Archived from groups: microsoft.public.windowsxp.basics (More info?)

Emily N wrote:
> I have been reformatting spreadsheets that other people have sent me. I have
> received some that people have put in all caps. I haven't known how to change
> it from all caps to first letter capitalized easily, so I've had to retype
> them. Does anyone know if this is possible or if retyping is my only option?
-------------

You probably want to ask this in the Excel forum, not in the XP forum.

There are Excel functions such as LOWER() which will reduce all
characters to lower case, and then you'd have to manually change only
one character. Or PROPER() which will capitalize the first letter of
each word, and make the rest lower case.

Good luck...

Bill
!