Can I change upper case letters to down case automatically?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sirritys - 03 Jul 2006 06:04 GMT

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

Reply to this Message

RobertVA - 03 Jul 2006 07:59 GMT

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

Reply to this Message

Sirritys - 03 Jul 2006 11:26 GMT

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

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

Reply to this Message

Bill Ridgeway - 03 Jul 2006 11:52 GMT

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

> Hi,
>
[quoted text clipped - 7 lines]
>>
>> LOWER("E. E. Cummings") equals "e. e. cummings"

Reply to this Message

Bill Ridgeway - 03 Jul 2006 08:16 GMT

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

> 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

Reply to this Message

Dave Peterson - 03 Jul 2006 13:20 GMT

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

> 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

Signature

Dave Peterson

Reply to this Message

Traveller - 03 Jul 2006 15:08 GMT

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

> 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

Reply to this Message

Sirritys - 04 Jul 2006 08:40 GMT

Thanks mates,

those advices will help a lot

-Sirritys

Reply to this Message

Traveller - 04 Jul 2006 14:33 GMT

Glad to hear it!

> Thanks mates,
>
> those advices will help a lot
>
> -Sirritys

Reply to this Message

Rate this thread: