Trick - Creating "Addressee Labels" in Excel



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]


31417 Views 7 Likes Comment   Share Students   Report


About the Author

Trainer

/coaching/excel.asp

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details