Forum Discussion
sf49ers19238597
Mar 24, 2024Iron Contributor
I try put three cells in one cell automatically
I try put three cells in one cell automatically. I have sample one done on a file How get rest done without type it or copy and paste.
Thanks You
- m_tarlerSteel Contributorthe simpliest is just =CONCAT(A3:C3) and then copy down
but you could also use CONCATENATE or TEXTJOIN - Harun24HRBronze Contributor
sf49ers19238597 You can use simply CONCAT() function like-
=CONCAT(A2:C2)
To make it dynamic spill array, you may use BYROW() function with CONCAT().
=BYROW(A2:INDEX(C:C,COUNTA(A:A)),LAMBDA(rw,CONCAT(rw)))
- Patrick2788Silver Contributor1. Delete column D
2. Go to D3 and press Ctrl+E
3. Enjoy