Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Step 1 – Concatenate (join) the cell contents using & and use CHAR(10) wherever you want the item to shift to the next line. CHAR(10) will help synthetically create the effect of ALT+ENTER or line break

Step 2 – Select the cell(s) where the formula has been entered and apply WRAP TEXT. It will activate the effect of line break as created by CHAR(10)

To read CA. Rishabh Pugalia’s other articles on Excel tricks on CAClubindia.com, click here:


To attend his LIVE workshop in Kolkata or Mumbai, click here:

[excelnext_workshop.zip as attached in the email]

To subscribe to CA. Rishabh Pugalia’s Online Training Program at CAClubinda.com, click here:


Tags :

Category Students, Other Articles by - CA Rishabh Pugalia (ExcelNext)