Can I change upper case letters to down case automatically?

[Sirritys]

Hi,

I was just wondering if there is an easy way to change all uppper case
letters in cells ins spesific range to down case?

-Sirritys

 

[RobertVA]

Hi,

I was just wondering if there is an easy way to change all uppper case
letters in cells ins spesific range to down case?

-Sirritys

From Excel '97 help:

Examples

LOWER("E. E. Cummings") equals "e. e. cummings"

 

[Bill Ridgeway]

I've found changing case in Excel rather limiting. I would rather copy and
paste the whole lot into Word, make the change there and then copy and past
back into Excel. However, this may be a bitty job if you have a large
spreadsheet.

Regards.

Bill Ridgeway
Computer Solutions

 

[Sirritys]

Hi,

Yes, I think this would work, but requires me to copy cells to other
worksheet. I was wondering if there is i.e. an easy macro that could
change them there where they are.

-Sirritys

 

[Bill Ridgeway]

Whilst in Excel you have the choice of 'upper', 'lower' and 'proper' (title)
case, in Word you have, in addition, 'sentence' and 'toggle' case which may
be useful and worth the cutting and pasting.

Regards.

Bill Ridgeway
Computer Solutions

 

[Dave Peterson]

See Chip Pearson's site:
http://cpearson.com/excel/case.htm

for a macro solution.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Guest]

ASAP Utilities is a wonderful free add-in that performs something like 300
useful functions in one easy step, including changing upper case to lower
case.

Google "ASAP Utilities."

 

[Sirritys]

Thanks mates,

those advices will help a lot

-Sirritys

 

[Guest]

Glad to hear it!