Changing case of text in multiple cells

  • Thread starter Thread starter compy386
  • Start date Start date
C

compy386

Is there a way to modify the case of text in a cell other than to edi
the content and retype it?

I have entered some text in cells. The text is in all capital letters
(e.g "CELL ENTRY") Is there an easy way for me to change it so that i
reads in all lowercase letters (e.g. "cell entry" instead of "CEL
ENTRY") or can I keep it so the first letter stays capitalized and th
rest of the word is lowercased ("Cell Entry")?

The latter would be better.

I have done this over a range of cells, so I'd prefer to not have to g
through to each one individually and retype my entry.

I know there's a way to do it in MS Word, but I don't know if the sam
options are available in XL.

Thanks in advance for your help. Have a nice day
 
Hi
one way:
in an adjacent column enter the formula
=PROPER(A1)
and copy this down (if A is the column with your entries)

After this select this column and copy it (CTRL+C). Goto 'Edit - Paste
Special' and insert the column as 'Values' to overwrite the formulas.
 
Back
Top