Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Error
Forgive me if this is a duplicate post. I thought I posted this question on
Friday, but have not had any responses, and can't find the original through the search box. I am using Windows 2007, but saw this error occasionally with 03. When using concatenate, if I drag the formula down the column, all the boxes fill with the same result. When I click on each box, the formula is correct, but the result uses the text from the very first row. Ex: say I'm concatenating names col. A is name & col. B is job title. All columns fill with "Abraham Lincoln, President" which would be in row 1, but the formulas are correct for all following rows. =CONCATENATE(C3,", ",D3) A co-worker who tried to help me noticed that when clicking "save" the results change to the proper text (ex: Thomas Edison, Inventor). We had tried cutting/pasting to new columns & even a new workbook. We thought it was a fluke/hiccup in the particular workbook I was using, but it just happened again in a completely different workbook. Anyone know what's going on or how to fix it? Will I always have to save everytime I want to concatenate? NicoleS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenate Error
Make sure calculation is set to automatic.
In Excel 2007: Formulas tabCalculationCalculation OptionsAutomatic All other versions of Excel: ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "NicoleS" wrote in message ... Forgive me if this is a duplicate post. I thought I posted this question on Friday, but have not had any responses, and can't find the original through the search box. I am using Windows 2007, but saw this error occasionally with 03. When using concatenate, if I drag the formula down the column, all the boxes fill with the same result. When I click on each box, the formula is correct, but the result uses the text from the very first row. Ex: say I'm concatenating names col. A is name & col. B is job title. All columns fill with "Abraham Lincoln, President" which would be in row 1, but the formulas are correct for all following rows. =CONCATENATE(C3,", ",D3) A co-worker who tried to help me noticed that when clicking "save" the results change to the proper text (ex: Thomas Edison, Inventor). We had tried cutting/pasting to new columns & even a new workbook. We thought it was a fluke/hiccup in the particular workbook I was using, but it just happened again in a completely different workbook. Anyone know what's going on or how to fix it? Will I always have to save everytime I want to concatenate? NicoleS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate error | Excel Discussion (Misc queries) | |||
concatenate expression error | Excel Worksheet Functions | |||
why do i sometimes get a "value" error when i try to concatenate? | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Use numbers in CONCATENATE formula without getting error | Excel Worksheet Functions |