Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
I've "inherited" a spreadsheet that I will use for a bulk mail merge. It is
in all capital letters. I'd like to change it so that it is not all caps. I found the auto correct function for use while typing, however, I haven't found a way to correct after-the-fact. Jo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Not sure if I understand correctly
Try this =PROPER(A2) this will Microsoft if you have MICROSOFT change the cell reference to yours -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "Jo4321" wrote: I've "inherited" a spreadsheet that I will use for a bulk mail merge. It is in all capital letters. I'd like to change it so that it is not all caps. I found the auto correct function for use while typing, however, I haven't found a way to correct after-the-fact. Jo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Select the cells you want to change and run this little macro:
Sub properr() For Each r In Selection r.Value = Application.WorksheetFunction.Proper(r.Value) Next End Sub -- Gary''s Student - gsnu200836 "Jo4321" wrote: I've "inherited" a spreadsheet that I will use for a bulk mail merge. It is in all capital letters. I'd like to change it so that it is not all caps. I found the auto correct function for use while typing, however, I haven't found a way to correct after-the-fact. Jo |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Hi,
Suppose the cells are A1:A10 In B1 enter the formula =PROPER(A1) Copy it down. Convert the column B formulas to values and replace the original data. There are free add-ins on the internet to do this to a selection via a macro. Take a look at this site http://www.cpearson.com/excel/ChangingCase.aspx Or very simple version: Sub ChangeCase() Dim cell As Range For Each cell In Selection cell.Value = WorksheetFunction.Proper(cell) Next cell End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jo4321" wrote: I've "inherited" a spreadsheet that I will use for a bulk mail merge. It is in all capital letters. I'd like to change it so that it is not all caps. I found the auto correct function for use while typing, however, I haven't found a way to correct after-the-fact. Jo |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Thanks everyone. I actually had found that "PROPER" earlier, but didn't realize I'd have to make a "dummy" column to use to make it work. Took care of it nicely. Thanks! Jo |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Be careful with this macro.
If any cells in the selection contain formulas they will be wiped out and converted to values only. Gord On Tue, 3 Mar 2009 08:02:02 -0800, Gary''s Student wrote: Select the cells you want to change and run this little macro: Sub properr() For Each r In Selection r.Value = Application.WorksheetFunction.Proper(r.Value) Next End Sub |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Be careful with this macro.
If any cells in the selection contain formulas they will be wiped out and converted to values only. Gord On Tue, 3 Mar 2009 08:04:01 -0800, Shane Devenshire wrote: Hi, Suppose the cells are A1:A10 In B1 enter the formula =PROPER(A1) Copy it down. Convert the column B formulas to values and replace the original data. There are free add-ins on the internet to do this to a selection via a macro. Take a look at this site http://www.cpearson.com/excel/ChangingCase.aspx Or very simple version: Sub ChangeCase() Dim cell As Range For Each cell In Selection cell.Value = WorksheetFunction.Proper(cell) Next cell End Sub |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing all caps to proper
Run this macro.
Sub Proper() Dim Cell As Range Application.ScreenUpdating = False For Each Cell In Selection Cell.Formula = Application.Proper(Cell.Formula) Next Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Tue, 3 Mar 2009 07:46:35 -0800, Jo4321 wrote: I've "inherited" a spreadsheet that I will use for a bulk mail merge. It is in all capital letters. I'd like to change it so that it is not all caps. I found the auto correct function for use while typing, however, I haven't found a way to correct after-the-fact. Jo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
Is there a way to change Lowercase or Proper to ALL CAPS? | Excel Worksheet Functions | |||
Converting All Caps to Proper casing | Excel Worksheet Functions | |||
How do I make some columns all caps and others proper? | Excel Discussion (Misc queries) | |||
How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) |