Can I change upper case letters to down case automatically?

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

Sirritys wrote:
> 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"

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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"

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

"Sirritys" <[email protected]> wrote in message
news:[email protected]...
> 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"
>

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

Sirritys wrote:
>
> 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

--

Dave Peterson

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

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

Thanks mates,

those advices will help a lot

-Sirritys

Glad to hear it!

"Sirritys" wrote:

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