Can I change upper case letters to down case automatically?

S

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
 
R

RobertVA

Sirritys said:
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
Click to expand...

From Excel '97 help:

Examples

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

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
 
S

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
 
B

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
 
T

Traveller

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