Trick - Creating "Addressee Labels" in Excel

CA Rishabh Pugalia (ExcelNext) , Last updated: 18 February 2014  
  Share


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]


CCI Pro

7 Likes   31332 Views

Comments


Related Articles


Loading


Popular Articles




CCI Pro
Follow us

CCI Articles

submit article