have you tried to Concatenate

example: =Concatenate(A1,B2,C3)
or =A1&B2&C3

"MDN" wrote:

Hello

I'd like to copy the contents from a group of cells and then paste all of
those contents into one cell on a different worksheet. How can I do this?