C
CT Man
Help is too confusing. I can tell from it that I have to do a formula for
proper case, but it is unclear how to do it
proper case, but it is unclear how to do it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tyro
If the upper case is in cell A1. Put this in cell B1 =PROPER(A1)
Tyro
Tyro
P
Per Erik Midtrød
Help is too confusing. I can tell from it that I have to do a formula for
proper case, but it is unclear how to do it
If you have your text i cell A1, but this formula in some other cell:
=Proper(a1)
Per Erik
C
CT Man
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this
C
CT Man
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this
G
Gord Dibben
Don't click on the fx button, just type Per's formula into a cell.
Also, open Help and type in "proper". When reading about that function there
will be a "how" button showing you how to copy the example formula to the
worksheet.
Also, since things like formulas are confusing, perhaps a basic tutorial in
Excel would assist.
Here are a few basic tutorials for Excel to get a beginner going.
http://www.usd.edu/trio/tut/excel/index.html
http://www.baycongroup.com/el0.htm
http://office.microsoft.com/en-us/training/CR061831141033.aspx
Gord Dibben MS Excel MVP
Also, open Help and type in "proper". When reading about that function there
will be a "how" button showing you how to copy the example formula to the
worksheet.
Also, since things like formulas are confusing, perhaps a basic tutorial in
Excel would assist.
Here are a few basic tutorials for Excel to get a beginner going.
http://www.usd.edu/trio/tut/excel/index.html
http://www.baycongroup.com/el0.htm
http://office.microsoft.com/en-us/training/CR061831141033.aspx
Gord Dibben MS Excel MVP
T
Tyro
If your name is "JOHN DOE" and is in cell A1, then select cell B1 and type
the following: =PROPER(A1) then press the enter key.
Tyro
the following: =PROPER(A1) then press the enter key.
Tyro
C
CT Man
OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks.
CT Man
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks.
CT Man
G
Gord Dibben
To change the entire used range on a worksheet at once would require a Macro.
Here is one to change all cells to Proper Case.
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
If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
or Ron de De Bruin's site on where to store macros.
http://www.rondebruin.nl/code.htm
In the meantime..........
First...create a backup copy of your original workbook.
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + r to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Run or edit the macro by going to Tool>Macro>Macros.
You can also assign this macro to a button or a shortcut key combo.
Gord
Here is one to change all cells to Proper Case.
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
If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
or Ron de De Bruin's site on where to store macros.
http://www.rondebruin.nl/code.htm
In the meantime..........
First...create a backup copy of your original workbook.
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + r to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Run or edit the macro by going to Tool>Macro>Macros.
You can also assign this macro to a button or a shortcut key combo.
Gord
G
Gloria
1. Enter the formula in the first cell (b2, for example)
2. Select the cell that contains the formula. You will notice a small black square on the bottom right corner of the cell.
3. Click on the tiny square and drag down to the end. Each cell will automatically be filled with the formula with the cell number referenced by the formula incremented in each cell.
If step 3 doesn't work:
3. Right click on the tiny square and drag down to the end. When you release the mouse, a menu will appear. Select "series".
*******************************************************
When all your data is converted appropriately, select the entire column, copy, right click in an empty column, and select 'paste special'. In the window that appears, select 'values'.
CTMa wrote:
OK, That helps me change 1 cell to Proper case.
08-Jan-08
OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks
CT Ma
:
Previous Posts In This Thread:
How do I change from upper case to proper case in excel 2002
Help is too confusing. I can tell from it that I have to do a formula fo
proper case, but it is unclear how to do it
If the upper case is in cell A1.
If the upper case is in cell A1. Put this in cell B1 =PROPER(A1
Tyro
I still don't understand. I have never used a formula.
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete thi
:
I still don't understand. I have never used a formula.
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this
:
Don't click on the fx button, just type Per's formula into a cell.
Don't click on the fx button, just type Per's formula into a cell
Also, open Help and type in "proper". When reading about that function ther
will be a "how" button showing you how to copy the example formula to th
worksheet
Also, since things like formulas are confusing, perhaps a basic tutorial i
Excel would assist
Here are a few basic tutorials for Excel to get a beginner going
http://www.usd.edu/trio/tut/excel/index.html
http://www.baycongroup.com/el0.htm
http://office.microsoft.com/en-us/training/CR061831141033.asp
Gord Dibben MS Excel MV
If your name is "JOHN DOE" and is in cell A1, then select cell B1 and type the
If your name is "JOHN DOE" and is in cell A1, then select cell B1 and typ
the following: =PROPER(A1) then press the enter key
Tyro
OK, That helps me change 1 cell to Proper case.
OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks
CT Ma
:
To change the entire used range on a worksheet at once would require a Macro.
To change the entire used range on a worksheet at once would require a Macro
Here is one to change all cells to Proper Case
Sub Proper(
Dim Cell As Rang
Application.ScreenUpdating = Fals
For Each Cell In Selectio
Cell.Formula = Application.Proper(Cell.Formula
Nex
Application.ScreenUpdating = Tru
End Su
If you're not familiar with VBA and macros, see David McRitchie's site fo
more on "getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
or Ron de De Bruin's site on where to store macros.
http://www.rondebruin.nl/code.htm
In the meantime..........
First...create a backup copy of your original workbook.
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + r to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Run or edit the macro by going to Tool>Macro>Macros.
You can also assign this macro to a button or a shortcut key combo.
Gord
Re: How do I change from upper case to proper case in excel 2002
If you have your text i cell A1, but this formula in some other cell:
=Proper(a1)
Per Erik
Submitted via EggHeadCafe - Software Developer Portal of Choice
Producer/Consumer Queue and BlockingCollection in C# 4.0
http://www.eggheadcafe.com/tutorial...6d-b81ee8d9b314/producerconsumer-queue-a.aspx
2. Select the cell that contains the formula. You will notice a small black square on the bottom right corner of the cell.
3. Click on the tiny square and drag down to the end. Each cell will automatically be filled with the formula with the cell number referenced by the formula incremented in each cell.
If step 3 doesn't work:
3. Right click on the tiny square and drag down to the end. When you release the mouse, a menu will appear. Select "series".
*******************************************************
When all your data is converted appropriately, select the entire column, copy, right click in an empty column, and select 'paste special'. In the window that appears, select 'values'.
CTMa wrote:
OK, That helps me change 1 cell to Proper case.
08-Jan-08
OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks
CT Ma
:
Previous Posts In This Thread:
How do I change from upper case to proper case in excel 2002
Help is too confusing. I can tell from it that I have to do a formula fo
proper case, but it is unclear how to do it
If the upper case is in cell A1.
If the upper case is in cell A1. Put this in cell B1 =PROPER(A1
Tyro
I still don't understand. I have never used a formula.
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete thi
:
I still don't understand. I have never used a formula.
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this
:
Don't click on the fx button, just type Per's formula into a cell.
Don't click on the fx button, just type Per's formula into a cell
Also, open Help and type in "proper". When reading about that function ther
will be a "how" button showing you how to copy the example formula to th
worksheet
Also, since things like formulas are confusing, perhaps a basic tutorial i
Excel would assist
Here are a few basic tutorials for Excel to get a beginner going
http://www.usd.edu/trio/tut/excel/index.html
http://www.baycongroup.com/el0.htm
http://office.microsoft.com/en-us/training/CR061831141033.asp
Gord Dibben MS Excel MV
If your name is "JOHN DOE" and is in cell A1, then select cell B1 and type the
If your name is "JOHN DOE" and is in cell A1, then select cell B1 and typ
the following: =PROPER(A1) then press the enter key
Tyro
OK, That helps me change 1 cell to Proper case.
OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks
CT Ma
:
To change the entire used range on a worksheet at once would require a Macro.
To change the entire used range on a worksheet at once would require a Macro
Here is one to change all cells to Proper Case
Sub Proper(
Dim Cell As Rang
Application.ScreenUpdating = Fals
For Each Cell In Selectio
Cell.Formula = Application.Proper(Cell.Formula
Nex
Application.ScreenUpdating = Tru
End Su
If you're not familiar with VBA and macros, see David McRitchie's site fo
more on "getting started".
http://www.mvps.org/dmcritchie/excel/getstarted.htm
or Ron de De Bruin's site on where to store macros.
http://www.rondebruin.nl/code.htm
In the meantime..........
First...create a backup copy of your original workbook.
To create a General Module, hit ALT + F11 to open the Visual Basic Editor.
Hit CRTL + r to open Project Explorer.
Find your workbook/project and select it.
Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.
Run or edit the macro by going to Tool>Macro>Macros.
You can also assign this macro to a button or a shortcut key combo.
Gord
Re: How do I change from upper case to proper case in excel 2002
If you have your text i cell A1, but this formula in some other cell:
=Proper(a1)
Per Erik
Submitted via EggHeadCafe - Software Developer Portal of Choice
Producer/Consumer Queue and BlockingCollection in C# 4.0
http://www.eggheadcafe.com/tutorial...6d-b81ee8d9b314/producerconsumer-queue-a.aspx