Oct 06 2020 11:14 PM
Hi Everyone,
I got a requirement that i need to merge multiple cells in to single cell with sequencing numbers. Need to know how to achieve this. Attached snap & Excel for your reference.
Any insights are highly appreciated.
Thanks
Sridhar Dasari
Oct 06 2020 11:35 PM
Solution
If you have access to the TEXTJOIN function, you may try something like this...
=TEXTJOIN(CHAR(10),TRUE,INDEX(A4:A6&". "&B4:B6,))
Select the formula cell and enable the Wrap Text and increase the column width as desired.
Oct 06 2020 11:51 PM
Thanks @Subodh_Tiwari_sktneer
Oct 06 2020 11:52 PM
You're Welcome @SridharDasari!
Oct 06 2020 11:35 PM
Solution
If you have access to the TEXTJOIN function, you may try something like this...
=TEXTJOIN(CHAR(10),TRUE,INDEX(A4:A6&". "&B4:B6,))
Select the formula cell and enable the Wrap Text and increase the column width as desired.