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:

[/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:

[www.caclubindia.com/coaching/excel.asp]


 

7 Likes   104 Shares   31017 Views

Comments


Related Articles


Loading



Popular Articles




caclubindia books caclubindia books Book


CCI Articles

submit article

Stay updated with latest Articles!




update