Strange Function Copy

[msnyc07]

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?

 

[Roger Govier]

Hi

Perhaps you are set to Manual Calculation
XL2003 Tools>Options>Calculation>Automatic

XL2007 Formulas tab>Calculation section>Calculation Options>Automatic



--
Regards
Roger Govier

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