I created a simple Concatenate Function

C2, " ", D2, " ", E2

Which worked e.g.

Big Red Apple

I filled that down

and though the formula filled correctly e.g

C3, " ", D3, " ", E3
C4, " ", D4, " ", E4
etc

The values are all

Big Red Apple

I seem to remember this working perfectly before, is there something I am
missing that I am going to slap my forehead about?

Hi

Perhaps you are set to Manual Calculation
XL2003 ToolsOptionsCalculationAutomatic

XL2007 Formulas tabCalculation sectionCalculation OptionsAutomatic



--
Regards
Roger Govier

"msnyc07" wrote in message
...
I created a simple Concatenate Function

C2, " ", D2, " ", E2

Which worked e.g.

Big Red Apple

I filled that down

and though the formula filled correctly e.g

C3, " ", D3, " ", E3
C4, " ", D4, " ", E4
etc

The values are all

Big Red Apple

I seem to remember this working perfectly before, is there something I am
missing that I am going to slap my forehead about?

__________ Information from ESET Smart Security, version of virus
signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4767 (20100113) __________

The message was checked by ESET Smart Security.

http://www.eset.com