Upper case to Lower case

hi all

is there a quick and easy way of changing text in Excel from upper to lower
case or visa versa? I believe there is some kind of formula you can create?
Is this the only way it can be done? I want to completely replace the
worksheet I have in upper to lower case.

Thank you.

Louise

Hi Louise

I use ASAP Utilities' add-in. It does this and much more! It's available
from here:
www.asap-utilities.com

Hope this helps.
Andy.

"Louise" <[email protected]> wrote in message
news:[email protected]...
> hi all
>
> is there a quick and easy way of changing text in Excel from upper to
> lower
> case or visa versa? I believe there is some kind of formula you can
> create?
> Is this the only way it can be done? I want to completely replace the
> worksheet I have in upper to lower case.
>
> Thank you.
>
> Louise

VBA?

Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If Not cell.HasFormula Then
cell.Value = LCase(cell.Value)
End If
Next cell


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Louise" <[email protected]> wrote in message
news:[email protected]...
> hi all
>
> is there a quick and easy way of changing text in Excel from upper to
lower
> case or visa versa? I believe there is some kind of formula you can
create?
> Is this the only way it can be done? I want to completely replace the
> worksheet I have in upper to lower case.
>
> Thank you.
>
> Louise

Hello Louise,
Try =LOWER(TEXT) converts all to lower case,
=UPPER(TEXT) convercts all to upper case,
=PROPER(TEXT) as near as possible it gives the text to you with the
Upper and Lower case text as MS sees it.

You just add you cell reference where I typed text.

Hope it helps.

Maxwell


"Bob Phillips" wrote:

> VBA?
>
> Dim cell As Range
> For Each cell In ActiveSheet.UsedRange
> If Not cell.HasFormula Then
> cell.Value = LCase(cell.Value)
> End If
> Next cell
>
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Louise" <[email protected]> wrote in message
> news:[email protected]...
> > hi all
> >
> > is there a quick and easy way of changing text in Excel from upper to
> lower
> > case or visa versa? I believe there is some kind of formula you can
> create?
> > Is this the only way it can be done? I want to completely replace the
> > worksheet I have in upper to lower case.
> >
> > Thank you.
> >
> > Louise
>
>
>

they're fantastic! Never seen those before.

Thank you.


"Andy" wrote:

> Hi Louise
>
> I use ASAP Utilities' add-in. It does this and much more! It's available
> from here:
> www.asap-utilities.com
>
> Hope this helps.
> Andy.
>
> "Louise" <[email protected]> wrote in message
> news:[email protected]...
> > hi all
> >
> > is there a quick and easy way of changing text in Excel from upper to
> > lower
> > case or visa versa? I believe there is some kind of formula you can
> > create?
> > Is this the only way it can be done? I want to completely replace the
> > worksheet I have in upper to lower case.
> >
> > Thank you.
> >
> > Louise
>
>
>

Hi, thanks for your post.
this is the one i've tried before but you have to keep the text in the
original cells too, don't you?
Louise

"Maxwell" wrote:

> Hello Louise,
> Try =LOWER(TEXT) converts all to lower case,
> =UPPER(TEXT) convercts all to upper case,
> =PROPER(TEXT) as near as possible it gives the text to you with the
> Upper and Lower case text as MS sees it.
>
> You just add you cell reference where I typed text.
>
> Hope it helps.
>
> Maxwell
>
>
> "Bob Phillips" wrote:
>
> > VBA?
> >
> > Dim cell As Range
> > For Each cell In ActiveSheet.UsedRange
> > If Not cell.HasFormula Then
> > cell.Value = LCase(cell.Value)
> > End If
> > Next cell
> >
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Louise" <[email protected]> wrote in message
> > news:[email protected]...
> > > hi all
> > >
> > > is there a quick and easy way of changing text in Excel from upper to
> > lower
> > > case or visa versa? I believe there is some kind of formula you can
> > create?
> > > Is this the only way it can be done? I want to completely replace the
> > > worksheet I have in upper to lower case.
> > >
> > > Thank you.
> > >
> > > Louise
> >
> >
> >

Thanks for the feedback! There are some good functions in there.

Andy.

"Louise" <[email protected]> wrote in message
news:[email protected]...
> they're fantastic! Never seen those before.
>
> Thank you.
>
>
> "Andy" wrote:
>
>> Hi Louise
>>
>> I use ASAP Utilities' add-in. It does this and much more! It's available
>> from here:
>> www.asap-utilities.com
>>
>> Hope this helps.
>> Andy.
>>
>> "Louise" <[email protected]> wrote in message
>> news:[email protected]...
>> > hi all
>> >
>> > is there a quick and easy way of changing text in Excel from upper to
>> > lower
>> > case or visa versa? I believe there is some kind of formula you can
>> > create?
>> > Is this the only way it can be done? I want to completely replace the
>> > worksheet I have in upper to lower case.
>> >
>> > Thank you.
>> >
>> > Louise
>>
>>
>>

Louise

After entering the formulas and returning the text in the format you want, copy
those cells and paste special>values(in place).

You can now delete the original cells.


Gord Dibben MS Excel MVP

On Fri, 31 Mar 2006 05:10:02 -0800, Louise <[email protected]>
wrote:

>Hi, thanks for your post.
>this is the one i've tried before but you have to keep the text in the
>original cells too, don't you?
>Louise
>
>"Maxwell" wrote:
>
>> Hello Louise,
>> Try =LOWER(TEXT) converts all to lower case,
>> =UPPER(TEXT) convercts all to upper case,
>> =PROPER(TEXT) as near as possible it gives the text to you with the
>> Upper and Lower case text as MS sees it.
>>
>> You just add you cell reference where I typed text.
>>
>> Hope it helps.
>>
>> Maxwell
>>
>>
>> "Bob Phillips" wrote:
>>
>> > VBA?
>> >
>> > Dim cell As Range
>> > For Each cell In ActiveSheet.UsedRange
>> > If Not cell.HasFormula Then
>> > cell.Value = LCase(cell.Value)
>> > End If
>> > Next cell
>> >
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > (remove nothere from email address if mailing direct)
>> >
>> > "Louise" <[email protected]> wrote in message
>> > news:[email protected]...
>> > > hi all
>> > >
>> > > is there a quick and easy way of changing text in Excel from upper to
>> > lower
>> > > case or visa versa? I believe there is some kind of formula you can
>> > create?
>> > > Is this the only way it can be done? I want to completely replace the
>> > > worksheet I have in upper to lower case.
>> > >
>> > > Thank you.
>> > >
>> > > Louise
>> >
>> >
>> >