from CAPITAL to lower case??

[KATSALAS]

i have 250 cells..
each cell has 2-5 words.
ALL ARE CAPITAL...

how can i convert it all but the first letter to lower case ...
or(if not possible)
how can i convert all to lower case including the first letter

 

[anubis]

Hello KATSALAS.

Here's one way, if you have another 250 cells to put formulae into.

=LEFT(A1,1)&LOWER(MID(A1,2,99999))

Change the ranges as you need to, and copy the formula across and/or down.

HTH

 

[Oaktree]

Perhaps =PROPER(A1) ?

 

[Norie]

Or you could use the PROPER worksheet function.

=PROPER(A1)

 

[KATSALAS]

thank you (You the man)

when i copy paste it i get #REF

 

[anubis]

When you paste which formula do you get the #REF? If it was mine, you will need to adjust your ranges to where the data is located.


For Oaktree and/or Norie. I never used PROPER before, nice response. Is there any way when using PROPER that the second, third, words etc would be lower case as well?

 

[KATSALAS]

both formulas work fine....thank you guys...

i got what i wanted a new colunm with the correct data ...when i delete the original colonm i get #REF

 

[Norie]

Don't delete the original column.

Copy the column with the formulas.

Select the original column and Edit>Paste Special... Values.

You can now delete the column with the formulas.

 

[KATSALAS]

THANK YOU ......