Formating Text to change "All CAPS" to proper format

[MacGuy]

I am having trouble establishing a formula and copying it to a column.

Here is what I have been doing:

1) Go to "Insert" in the menu bar
2) Select "Function"
3) Select "TEXT"
4) Select "PROPER"
5) Add Cell and Cell numbers in this format PROPER (L2:L820)
RESULT: It only works for the L2 Cell, I try to copy it to cells L3
through L820 and I get errors, and something called a "circular
reference."

I saw a MACRO posted where you could copy and paste it with the cell
values. It didn't work for me.
Help.

(Thanks in advance)

 

[CyberTaz]

HELLO-

You're getting the circular ref because the function is referring to the
entire range of cell. If the data is in L2:L820 & you use the PROPER fx in
M2, the fx should just read as =PROPER(L2) then copy it down to row 820.

HTH |:>)


On 4/8/05 9:29 PM, in article

I am having trouble establishing a formula and copying it to a column.

Here is what I have been doing:

1) Go to "Insert" in the menu bar
2) Select "Function"
3) Select "TEXT"
4) Select "PROPER"
5) Add Cell and Cell numbers in this format PROPER (L2:L820)
RESULT: It only works for the L2 Cell, I try to copy it to cells L3
through L820 and I get errors, and something called a "circular
reference."

I saw a MACRO posted where you could copy and paste it with the cell
values. It didn't work for me.
Help.

(Thanks in advance)

-- (e-mail address removed)

 

[MacGuy]

CyberTaz,

Still having issues. Still getting the circular reference. I seem to
be getting the procedure right, but I don't get the result I want.

I tried using the formula =PROPER(L2) then copying the formula and
pasting it down to row 820...didn't work. The column turned blue
around the cells as I moved the cursor down to select the cells within
column L...But, I still got the circular reference.

Should I call you on the phone? I'd be glad to give you a call.

 

[J Laroche]

MacGuy wrote on 2005/04/09 17:23:

CyberTaz,

Still having issues. Still getting the circular reference. I seem to
be getting the procedure right, but I don't get the result I want.

I tried using the formula =PROPER(L2) then copying the formula and
pasting it down to row 820...didn't work. The column turned blue
around the cells as I moved the cursor down to select the cells within
column L...But, I still got the circular reference.

Should I call you on the phone? I'd be glad to give you a call.

You seem to be putting in L2 the formula =PROPER(L2). That's a circular
reference. A formula cannot reference the cell it's in (except a few
exceptions). You have to put =PROPER(L2) anywhere but in L2, let's say M2.
Then grab the bottom right corner of M2 and moved down to copy the formula.

JL
Mac OS X 10.3.8, Office v.X 10.1.6

 

[MacGuy]

J.L. It Worked! Thanks.