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:
[/articles/article_display_list_by_member.asp?member_id=997936]
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:
CAclubindia
