Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula percentage problem | New Users to Excel | |||
formula problem | New Users to Excel | |||
problem with Array Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Baffling formula problem | Excel Discussion (Misc queries) |