Formula problem

J

Jennnifer

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
 
T

tim m

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.
 
G

Gord Dibben

Jennifer

Tools>Options>Calculation.

Check "Automatic".


Gord Dibben MS Excel MVP
 
Top