concatenate help

  • Thread starter Thread starter odeonbum
  • Start date Start date
O

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



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




------------------------------------------------
 
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.
 
Back
Top