software

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 he
www.asap-utilities.com

Hope this helps.
Andy.

quot;Louisequot; gt; wrote in message
news
gt; hi all
gt;
gt; is there a quick and easy way of changing text in Excel from upper to
gt; lower
gt; case or visa versa? I believe there is some kind of formula you can
gt; create?
gt; Is this the only way it can be done? I want to completely replace the
gt; worksheet I have in upper to lower case.
gt;
gt; Thank you.
gt;
gt; 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)

quot;Louisequot; gt; wrote in message
news
gt; hi all
gt;
gt; is there a quick and easy way of changing text in Excel from upper to
lower
gt; case or visa versa? I believe there is some kind of formula you can
create?
gt; Is this the only way it can be done? I want to completely replace the
gt; worksheet I have in upper to lower case.
gt;
gt; Thank you.
gt;
gt; 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.

Maxwellquot;Bob Phillipsquot; wrote:

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

they're fantastic! Never seen those before.

Thank you.quot;Andyquot; wrote:

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

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

quot;Maxwellquot; wrote:

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

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

Andy.

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

After entering the formulas and returning the text in the format you want, copy
those cells and paste specialgt;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 gt;
wrote:

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