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 wi

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 1999/-

Offer Price : INR 999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
Join CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Students   Report

Other Articles  
Comment   Share
7 Likes   31329 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro

Trending Online Classes

view all classess

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category