Problem with Concatenate Function

[martinbsp]

Hi

I have a problem with the "Concatenate" function in Excel 2002.

I can create the function in one individual cell and it works fine, s
for example I have the cells:

2 2

so after concatenation it gives me "22".


However, when I try and copy that formula (by dragging the cell dow
the column) the formula doesn't work properly.

So all I get is "22" copied. The formula itself HAS copied into th
new cells but just produces "22".

Any ideas?

Thanks

Marti

 

[Andy B]

Hi

Make sure that Calculation is set to Automatic in Tools/Options/Calculation

 

[Andy B]

Hi

I've just reread your question!! Sorry. Presumably, you are wanting the 22
to become 33 and then 44? If this is the case, you'll need to link your
formula to the row reference, so as the row number increases, so does the
value.
Something like this:
=CONCATENATE(ROW(),ROW())
can be used. If this was put into row 2, your result would be 22. You can
also use a plus or minus. So if you wanted 22 in row 6, you could use
=CONCATENATE(ROW()-4,ROW()-4)

Hope this helps.
--
Andy.

Hi

Make sure that Calculation is set to Automatic in Tools/Options/Calculation

 

[martinbsp]

Perfect, thankyou very much.

Hi

Make sure that Calculation is set to Automatic i
Tools/Options/Calculation

 

[Guest]

Hi Martin

The first thing what comes into my mind is, that Tools - Options - Calculation is set to Manual and not Automatic

Go there and check what is entered or press [F9] recalculate manually

Bernd

 

[martinbsp]

Hi

I've just reread your question!! Sorry. Presumably, you are wantin
the 22
to become 33 and then 44? If this is the case, you'll need to lin
your
formula to the row reference, so as the row number increases, so doe
the
value.
Something like this:
=CONCATENATE(ROW(),ROW())
can be used. If this was put into row 2, your result would be 22. Yo
can
also use a plus or minus. So if you wanted 22 in row 6, you coul
use
=CONCATENATE(ROW()-4,ROW()-4)

Hope this helps.
--
Andy.





Andy

you were right first time round. Thanks.


And thanks to other contributors too.

Marti