Copy-Paste Multiple Cells Into One Single Cell in Excel

[@xnitinxx]

Alternatively, copy the cells (ctrl+C), select cell where you want to paste, click on formula bar and paste.

[@LouisDeconinck]

Are you sure? In the video I demonstrate this approach and it does not work.

[@leerobs1118]

Great stuff. Thanks. I've been using excel for years and just couldn't figure out how to do the ALT Enter trick🎉🎉 thanks

[@LouisDeconinck]

Happy to help, always great to discover some new Excel tricks.

[@MoaazBinImran]

How do you do it on a mac? There is no option of a clipboard pane but it does work by pasting in the formula bar.

[@ExcelTutorials1]

This is an awesome trick!! I always love time saving shortcuts like this :)

[@LouisDeconinck]

Thanks for the kind words, I'll try and post more of these tricks.

[@johnnyz7752]

Don’t press ALT and ENTER at the same time. Hold down ALT and press ENTER while holding down the ALT key.

[@LouisDeconinck]

My bad, thanks for the clarification!

[@thefacelessbiz]

Much needed. Thank you.

[@LouisDeconinck]

Glad it was helpful!

[@sv6856]

What about the other way ? From group to multiple copying?

[@steventezcan689]

Great info! thank you so much!

[@LouisDeconinck]

Glad it was helpful!

[@Viatan]

you are the best! :D

[@chakralamurali]

Excellent sir

[@LouisDeconinck]

So nice of you!

[@KrishnaKumar-zn9kg]

Good one. Thanks.

[@LouisDeconinck]

Glad you liked it!

[@surajkoshti40]

How to copy all minus values from different cell into one cell

[@spen2431]

Can you do it the other way? ie Have all the data in one cell... and then paste it over multiple rows?

[@LouisDeconinck]

That's a very interesting question, however, as far as I know that's not possible.

[@saikrishna72870]

Yes , you can Do it By Power query ,

[@ExcelUnder5Minutes]

You can do it with this formula: =TRANSPOSE(TEXTSPLIT(G7,CHAR(10))) Just change G7 to whichever cell you want to break up to multiple

[@thekeyboardguy815]

How do I do the same thing if I have multiple set of 5 cells to paste in a single cell?

[@LouisDeconinck]

Just put the 5 cells underneath each other and then copy them.

[@thekeyboardguy815]

​@@LouisDeconinck Apologies for not being clear, Assume that I have 20 letters from the alphabet in 20 rows starting from letter A all the way till the letter T, Now , is it possible to "merge" or "paste" the set of five letters in a single cell i.e., (A-E) , (F-J) , (K-O), (P-T), in 4 different cells ??

[@LouisDeconinck]

@@thekeyboardguy815 I'm not sure, but I think you could achieve something like that with the TEXTJOIN function.

[@ExcelTutorials1]

you got a sub from me for this cool trick

[@LouisDeconinck]

Thanks for the sub!

[@Agarwala_Rahul]

Good

[@LouisDeconinck]

Thanks!

[@tedmoy]

Should mention how to using shortcuts :)

[@LouisDeconinck]

Thanks for the suggestion, I'll try to mention shortcuts more often in my future videos.

[@tedmoy]

@@LouisDeconinckThank you!! You look like Icarus in Eternals by the way.

[@LouisDeconinck]

@@tedmoy Thanks for the compliment!

[@yousrymaarouf2931]

Good

[@LouisDeconinck]

Thanks!