Formula problem

[Guest]

When selecting formula =proper(cell) for a list of text the results return
the first line only and the following lines have the same result as the first
line.

For example:
HONG KONG =proper(cell 1) results: Hong Kong
CHINA =proper(cell 2) results: Hong Kong
INDIA =proper(cell 3) results: Hong Kong
EUROPE =proper(cell 4) results: Hong Kong

 

[Guest]

Are the cell references absolute? As in if Hong Kong is in A1 and the
formula says =$A$1 and it is copied down it will always produce 'Hong Kong'
If the formula is =A1 and is copied down it should advance to A2, A3 etc and
show the other locations.

 

[Ryan Christiansen]

Can I ask a dumb question? Are you using absolute references? For
example, for HONG KONG are you referencing that cell, for example,
using

=PROPER($A$1)

with dollar signs in the reference. My first guess is that you copied
this to the other cells, but because you're using absolute references,
all of the cells you copied to continue to reference cell A1.

What you need is

=PROPER(A1)

without dollar signs.

Does that help? Or am I way off?

-Ryan

 

[Guest]

NO there are no absolute references in the the cells.

 

[Gord Dibben]

Jennifer

Tools>Options>Calculation.

Check "Automatic".


Gord Dibben MS Excel MVP

 

[Guest]

Thank you that solved my problem.

Jennifer

Tools>Options>Calculation.

Check "Automatic".


Gord Dibben MS Excel MVP