concatenate help

[odeonbum]

Hello, I am having issues with the CONCATENATE function. I am entering
it correctly, and it is equaling the correct values. However, when I
try to drag the cell down, it is just copying the same cell over and
over as opposed to putting the correct value in the cell. Am I being
clear? Please help. I have a list due tomorrow that will take a whole
lot more time to finish if I can't get this function to work.

Thanks



------------------------------------------------




------------------------------------------------

 

[Laura Cook]

Make sure that "Automatic" is check in Tools > Options > Calculation (tab)

 

[Ken Wright]

And you also don't really need to use CONCATENATE.

=A1&B1&C1

or

=A1&" "&B1&" "&C1 if you want spaces

or

=A1&","&B1&","&C1 if you want commas etc

will do the same kind of thing.