Prev: count between a date range
Next: What is 3% of 1061? (homework?)
From: Gloria on 2 Jun 2010 07:25
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 Man

"Gord Dibben" wrote:

Previous Posts In This Thread:

On Monday, January 07, 2008 5:26 PM
CTMa wrote:

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 for
proper case, but it is unclear how to do it

On Monday, January 07, 2008 5:32 PM
Tyro wrote:

If the upper case is in cell A1.
If the upper case is in cell A1. Put this in cell B1 =PROPER(A1)

Tyro

On Monday, January 07, 2008 5:44 PM
CTMa wrote:

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

"Per Erik Midtr??d" wrote:

On Monday, January 07, 2008 5:44 PM
CTMa wrote:

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

"Per Erik Midtr??d" wrote:

On Monday, January 07, 2008 6:10 PM
Gord Dibben wrote:

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 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

On Mon, 7 Jan 2008 14:44:01 -0800, CT Man <CTMan(a)discussions.microsoft.com>
wrote:

On Monday, January 07, 2008 6:19 PM
Tyro wrote:

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 type
the following: =PROPER(A1) then press the enter key.

Tyro

On Tuesday, January 08, 2008 8:41 AM
CTMa wrote:

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 Man

"Gord Dibben" wrote:

On Tuesday, January 08, 2008 1:14 PM
Gord Dibben wrote:

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 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

On Tue, 8 Jan 2008 05:41:01 -0800, CT Man <CTMan(a)discussions.microsoft.com>
wrote:

On Tuesday, January 08, 2008 11:06 PM
=?ISO-8859-1?Q?Per_Erik_Midtr=F8d?= wrote:

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/tutorials/aspnet/7d10d73c-321c-446e-8b6d-b81ee8d9b314/producerconsumer-queue-a.aspx
 | 
Pages: 1
Prev: count between a date range
Next: What is 3% of 1061? (homework?)