ALL CAPS to regular text?

[Guest]

Can you make ALL CAPS text change to lower case automatically, without
re-typing?

 

[Guest]

Try
=lower(A1)

 

[Paul B]

VMS, you can put something like =LOWER(A1) in another column and copy down,
then paste back over your data or use a macro like this

Sub Make_Lower_Case()
'select range and run this to change to all lower case
Dim cel As Range
Application.ScreenUpdating = False
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = LCase$(cel.Formula)
Next
Application.ScreenUpdating = True
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

I get some error about circular reference. I'm such a novice, I may need
more detailed instructions. Thanks.

VMS, you can put something like =LOWER(A1) in another column and copy down,
then paste back over your data or use a macro like this

Sub Make_Lower_Case()
'select range and run this to change to all lower case
Dim cel As Range
Application.ScreenUpdating = False
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = LCase$(cel.Formula)
Next
Application.ScreenUpdating = True
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

vms, to use the lower function you would reference the cell with the text
you want to change so if the text is in column A you would put =LOWER(A1) in
a empty column and copy it down to the last row that you want to change, to
copy it down click your mouse on the little black box in the bottom right
hand corner of the cell and drag it down, you will then have the data
changed to lower case, highlight the lower case data, right click and copy
then select A1, in this example and right click and paste special, valves,
now your data should be lower case, delete the data with the lower formula
in it, if you need more help post back with how you date is in the sheet and
what you want to change
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

I get some error about circular reference. I'm such a novice, I may need
more detailed instructions. Thanks.

 

[SarahKay]

WOW! thanks! i never knew you could change the text from lower to upper
with just a code. I have to move data that is sent to me onto another
database and most of the time it is sent to me with lower case (when it
should be upper) and vice versa.
now i dont have to keep pestering them! Thanks!