Changing Uppercase to Lowercase

I have been supplied a huge Excel file, but all the text has been entered as
CAPS. Is there anyway in Excel that you can change this to Upper and
Lowercase or just lowercase would do.

I am using Excel 2000 on an XP PC.

Any help would be gratefully received.

Jim
Tue May 09 11:37:13 CDT 2006

You have to use helper columns and the built-in functions
Proper or Lower to do that or...

The free Excel add-in "Excel Extras" will do that.
It has upper, lower, proper and sentence case options
added to the format menu. Does other stuff too.
Download from... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"SLEDGE"
<SLEDGE@discussions.microsoft.com>
wrote in message
I have been supplied a huge Excel file, but all the text has been entered as
CAPS. Is there anyway in Excel that you can change this to Upper and
Lowercase or just lowercase would do.
I am using Excel 2000 on an XP PC.
Any help would be gratefully received.

SLEDGE
Tue May 09 13:00:02 CDT 2006

Jim

It works fine thanks. It is kind people like you that take time out to help
people like me, that makes it all worth while.

Thank you very much

"Jim Cone" wrote:

> You have to use helper columns and the built-in functions
> Proper or Lower to do that or...
>
> The free Excel add-in "Excel Extras" will do that.
> It has upper, lower, proper and sentence case options
> added to the format menu. Does other stuff too.
> Download from... http://www.realezsites.com/bus/primitivesoftware
> --
> Jim Cone
> San Francisco, USA
>
>
> "SLEDGE"
> <SLEDGE@discussions.microsoft.com>
> wrote in message
> I have been supplied a huge Excel file, but all the text has been entered as
> CAPS. Is there anyway in Excel that you can change this to Upper and
> Lowercase or just lowercase would do.
> I am using Excel 2000 on an XP PC.
> Any help would be gratefully received.
>

JoshuaJacoby
Tue May 09 13:25:02 CDT 2006

Is this trevor?

"SLEDGE" wrote:

> Jim
>
> It works fine thanks. It is kind people like you that take time out to help
> people like me, that makes it all worth while.
>
> Thank you very much
>
> "Jim Cone" wrote:
>
> > You have to use helper columns and the built-in functions
> > Proper or Lower to do that or...
> >
> > The free Excel add-in "Excel Extras" will do that.
> > It has upper, lower, proper and sentence case options
> > added to the format menu. Does other stuff too.
> > Download from... http://www.realezsites.com/bus/primitivesoftware
> > --
> > Jim Cone
> > San Francisco, USA
> >
> >
> > "SLEDGE"
> > <SLEDGE@discussions.microsoft.com>
> > wrote in message
> > I have been supplied a huge Excel file, but all the text has been entered as
> > CAPS. Is there anyway in Excel that you can change this to Upper and
> > Lowercase or just lowercase would do.
> > I am using Excel 2000 on an XP PC.
> > Any help would be gratefully received.
> >

Jim
Tue May 09 14:30:11 CDT 2006

You are welcome.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"SLEDGE"
<SLEDGE@discussions.microsoft.com>
wrote in message
Jim
It works fine thanks. It is kind people like you that take time out to help
people like me, that makes it all worth while.
Thank you very much



"Jim Cone" wrote:
> You have to use helper columns and the built-in functions
> Proper or Lower to do that or...
> The free Excel add-in "Excel Extras" will do that.
> It has upper, lower, proper and sentence case options
> added to the format menu. Does other stuff too.
> Download from... http://www.realezsites.com/bus/primitivesoftware
> Jim Cone
> San Francisco, USA



> "SLEDGE"
> <SLEDGE@discussions.microsoft.com>
> wrote in message
> I have been supplied a huge Excel file, but all the text has been entered as
> CAPS. Is there anyway in Excel that you can change this to Upper and
> Lowercase or just lowercase would do.
> I am using Excel 2000 on an XP PC.
> Any help would be gratefully received.