software

I know that a formula would work, but I don't know what it is
and more importantly, where to put it.

In other words, if the quot;all caps namequot; is in E3 to E120

and I want to change these cells to quot;proper casequot;

Note that I already tried putting this formula in A1
=PROPER(A2)

to change an quot;all capsquot; name in A2, but it didn't change it.

What exactly do I do for this?

If you will be providing me with a formula, then please tell me exactly
where to put it and how to put it there.

Thanks so much
--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=535552You can't change the existing cells, in blank cells, put in =proper(E3) and
the proper name will show up in the cell you put the formula in. Then you
have to do a copy / paste special /values to turn the formula into the
actual names.

quot;duuggquot; wrote:

gt;
gt; I know that a formula would work, but I don't know what it is
gt; and more importantly, where to put it.
gt;
gt; In other words, if the quot;all caps namequot; is in E3 to E120
gt;
gt; and I want to change these cells to quot;proper casequot;
gt;
gt; Note that I already tried putting this formula in A1
gt; =PROPER(A2)
gt;
gt; to change an quot;all capsquot; name in A2, but it didn't change it.
gt;
gt; What exactly do I do for this?
gt;
gt; If you will be providing me with a formula, then please tell me exactly
gt; where to put it and how to put it there.
gt;
gt; Thanks so much
gt;
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=535552
gt;
gt;

Hi duugg,

What results is the formula returning exactly? That should be the formula
you need...

--
Regards,
Zack Barresse, aka firefytrquot;duuggquot; gt; wrote in
message ...
gt;
gt; I know that a formula would work, but I don't know what it is
gt; and more importantly, where to put it.
gt;
gt; In other words, if the quot;all caps namequot; is in E3 to E120
gt;
gt; and I want to change these cells to quot;proper casequot;
gt;
gt; Note that I already tried putting this formula in A1
gt; =PROPER(A2)
gt;
gt; to change an quot;all capsquot; name in A2, but it didn't change it.
gt;
gt; What exactly do I do for this?
gt;
gt; If you will be providing me with a formula, then please tell me exactly
gt; where to put it and how to put it there.
gt;
gt; Thanks so much
gt;
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=535552
gt;

dlw

If I put the formula into cell , I get the following error message
=PROPER(#REF!). Then I put the name, let's say, John Smith in the same
cell, but it types over the formula, resulting in erasing it.

I also tried putting quot;=Proper (A2)quot; into cell A1 and then typing john
smith (just like that, all lowercase) in cell A2, but it does not
change the case to proper after pressing enter, it just stays like it
was.--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=535552The #REF! is generally from deleting or cutting the referenced cell (if
you're seeing it in the formula itself). When you change the #REF! to A2
and change A2 value to quot;john doequot; (w/o quotes), what does the formula read?
If the same, press F9, what does the formula read? If the same, select your
formula, press F2 then Enter, what does it read now?

--
Regards,
Zack Barresse, aka firefytr
quot;duuggquot; gt; wrote in
message ...
gt;
gt; dlw
gt;
gt; If I put the formula into cell , I get the following error message
gt; =PROPER(#REF!). Then I put the name, let's say, John Smith in the same
gt; cell, but it types over the formula, resulting in erasing it.
gt;
gt; I also tried putting quot;=Proper (A2)quot; into cell A1 and then typing john
gt; smith (just like that, all lowercase) in cell A2, but it does not
gt; change the case to proper after pressing enter, it just stays like it
gt; was.
gt;
gt;
gt; --
gt; duugg
gt; ------------------------------------------------------------------------
gt; duugg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33372
gt; View this thread: www.excelforum.com/showthread...hreadid=535552
gt;

Zack,

We'll it works if I type the name, erase it, and then re-type it. I
want to use this formula on 120 pre-existing cells. If I have to erase
it, and then retype it, it will defeat the purpose.

Is there a way to use this on pre-existing data. Obviously, even if I
have to copy and paste a column into a blank worksheet to do this, it
would be okay.

If so, do I insert a row above all others to put the formula in just to
correct the text entries below that I want to change the case on?--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=535552
Zack,

We'll it works if I type the name, erase it, and then re-type it. I
want to use this formula on 120 pre-existing cells. If I have to erase
it, and then retype it, it will defeat the purpose.

Is there a way to use this on pre-existing data. Obviously, even if I
have to copy and paste a column into a blank worksheet to do this, it
would be okay.

If so, do I insert a row above all others to put the formula in just to
correct the text entries below that I want to change the case on?--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=535552
Zack,

We'll it works if I type the name, erase it, and then re-type it. I
want to use this formula on 120 pre-existing cells. If I have to erase
it, and then retype it, it will defeat the purpose.

Is there a way to use this on pre-existing data. Obviously, even if I
have to copy and paste a column into a blank worksheet to do this, it
would be okay.

If so, do I insert a row above all others to put the formula in just to
correct the text entries below that I want to change the case on?--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=535552duugg

Assume the names are in in cells E1:E120

Also assume your calculation mode is set to automatic under
Toolsgt;Optionsgt;Calculation.

In F1 enter =PROPER(E1)

Hover the mouse pointer over the bottom right corner of F1 untill you see a
black cross. Double-click on that cross to copy the formula down to F120

I believe your mistake is you are trying to enter a formula and the name in the
same cell.

Cannot be done.Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 13:06:03 -0500, duugg
gt; wrote:

gt;
gt;Zack,
gt;
gt;We'll it works if I type the name, erase it, and then re-type it. I
gt;want to use this formula on 120 pre-existing cells. If I have to erase
gt;it, and then retype it, it will defeat the purpose.
gt;
gt;Is there a way to use this on pre-existing data. Obviously, even if I
gt;have to copy and paste a column into a blank worksheet to do this, it
gt;would be okay.
gt;
gt;If so, do I insert a row above all others to put the formula in just to
gt;correct the text entries below that I want to change the case on?
Ugh! This is driving me crazy! Why is it not changing the names to
proper??

Sorry everyone, I feel oblivious to this. I've attached a pic of the
spreadsheet to show everyone that it's not changing the text to
proper.

I do have it set to automatic as well.

Again, thanks for everyone's help on this. -------------------------------------------------------------------
|Filename: untitled 4.bmp |
|Download: www.excelforum.com/attachment.php?postid=4689 |
-------------------------------------------------------------------

--
duugg
------------------------------------------------------------------------
duugg's Profile: www.excelforum.com/member.php...oamp;userid=33372
View this thread: www.excelforum.com/showthread...hreadid=535552