NO there are no absolute references in the the cells.

"Ryan Christiansen" wrote:

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

Jennnifer wrote:
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