Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ALL CAPS to regular text?
Can you make ALL CAPS text change to lower case automatically, without
re-typing? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar |
#2
|
|||
|
|||
Try
=lower(A1) "vms" wrote: Can you make ALL CAPS text change to lower case automatically, without re-typing? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar |
#3
|
|||
|
|||
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 "vms" wrote in message ... Can you make ALL CAPS text change to lower case automatically, without re-typing? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar |
#4
|
|||
|
|||
I get some error about circular reference. I'm such a novice, I may need
more detailed instructions. Thanks. "Paul B" wrote: 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 "vms" wrote in message ... Can you make ALL CAPS text change to lower case automatically, without re-typing? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar |
#5
|
|||
|
|||
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 "vms" wrote in message ... I get some error about circular reference. I'm such a novice, I may need more detailed instructions. Thanks. "Paul B" wrote: 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 "vms" wrote in message ... Can you make ALL CAPS text change to lower case automatically, without re-typing? -- "You can have everything in life you want, if you will just help enough other people get what they want." -- Zig Ziglar |
#6
|
|||
|
|||
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! -- SarahKay ------------------------------------------------------------------------ SarahKay's Profile: http://www.excelforum.com/member.php...o&userid=24330 View this thread: http://www.excelforum.com/showthread...hreadid=379146 |
#7
|
|||
|
|||
Wowsers, there's a lot of great tips in here.... just wanted to say thanks for this one, like the previous poster I had no clue that I could do that. I just looked it up and you can change to upper, lower, or proper (title case) with a few simple formulas. I couldn't find one that would convert to Sentence case though. But that's usually not desired in Excel anyway, so I don't care. Thanks yall!!!!!! This is actually kinda fun... :) -VB -- myplaygroundismyoffice ------------------------------------------------------------------------ myplaygroundismyoffice's Profile: http://www.msusenet.com/member.php?userid=2247 View this thread: http://www.msusenet.com/t-1870536453 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change from all caps to regular for existing data? | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Changing text from all caps to first letter cap | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Making text all CAPS in excel | Excel Worksheet Functions |