Formula problem
 

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

Formula problem
 

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.

"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

Formula problem
 

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

Formula problem
 

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

Formula problem
 

Jennifer

ToolsOptionsCalculation.

Check "Automatic".


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 12:17:02 -0700, 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

Formula problem
 

Thank you that solved my problem.

"Gord Dibben" wrote:

Jennifer

ToolsOptionsCalculation.

Check "Automatic".


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 12:17:02 -0700, 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