quick way to concatenate cells

[Chrissirhc]

Hi,

If I have stuff in some cells going downwards e.g.

Chris
John
Michelle
etc

If I want to concatenate them I can use A1&A2&A3...

What is the quickest way to do this, if say I have 300 rows of data?

Thanks,

Chris

 

[GlennUK]

Download Morefunc addin from Laurent Longre, and use the MCONCAT function. Look here:

http://xcell05.free.fr/english/

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Chrissirhc]

Is there a way without downloading the addin or writing the function oneself?

 

[combo]

Try CONCATENATE built-in excel function.

combo

 

[GlennUK]

Hi Chris,

you could do it column B, adding one name at a time down the column. So B1 would have =A1 as it formula, then B2 would have =B1&A2 and then you'd copy that formula down as required.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Chrissirhc]

Concatenate doesn't work. It returns #value unless you type in all the cells manually which is just as long as doing A1&A2&A3...

Doing the copy down also does not work unfortunately. It just does copy and paste...

Thanks for the replies though.

Thanks,

Chris

 

[GlennUK]

Doing the copy down also does not work unfortunately. It just does copy and paste...

Did you follow my instructions properly? If so, it should have worked. Explain exactly what you did ( if different from what I said ), and tell us what "does not work" actually means.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[taupirho]

i = 1
While Cells(i, 1) <> ""
x = x & Cells(i, 1)
i = i + 1

Wend

Cells(1, 2) = x