See

http://www.mcgimpsey.com/excel/subs/...mergeselection

for a way, using a macro, or for a UDF:

http://www.mcgimpsey.com/excel/udfs/multicat.html




In article . com,
Heine wrote:

Hello everybody,

I have text en cell a3 to a31 - does anybody know if it´s possible to
merge alle the text into one cell? Merge and center does not work - it
only take the text in cell a3.

Any thoughts?

best regards,

Heine