Address Cleanup turns messy, inconsistent address lists in Google Sheets into consistent, properly-formatted address lists in just a few clicks! Stationery designers often deal with formatting issues in our clients' address lists... enter the Address Cleanup Tool from Design by Laney!! Specifically, Address Cleanup will: 1) Spell out and standardize street abbreviations (Rd., St., etc.) 2) Spell out and standardize apartment abbreviations (Apt, Ste) 3) Spell out and standardize US State Abbreviations and Canadian Province Abbreviations (ie: CA to California) 4) Add a leading 0 on 4-digit zip codes! 5) (Optional) Capitalize the first letter of every word Note: this is NOT a guarantee that your addresses will be perfect, and is NOT an address verification tool. But we think it will help save you so much time in your initial setup - hope you love it! 🔗 Resources: • Address Cleanup Extension → https://designbylaney.com/address-cleanup • Data Merge Tutorial → https://youtu.be/sDsG-oaL_zE • Fave Vendors → https://designbylaney.com/stationery-vendor-toolkit ~ Links contained in the video and/or description may be affiliate links which earn us a small commission at no cost to you! We appreciate your use of our links so we can continue making free content for you! ---------- Hi, hey, hello! Welcome to the Design by Laney channel! I am a wedding invitation designer & stationery business educator! On this channel, you'll find videos featuring design tutorials, systems reviews, and the most requested tips and tricks for running a creative business - yes, including my favorite printers! New to Invitation Design? 💌 Check out our *From Start to Suite* course! https://designbylaney.com/from-start-to-suite 🤓 Sign up for our FREE Adobe Illustrator course series: https://designbylaney.com/free-illustrator-course 👩🏻🏫 Want to learn even more about running a stationery business? Join us in Stationery School! https://designbylaney.com/stationery-school 💛 Follow Along: www.instagram.com/designbylaney www.designbylaney.com www.facebook.com/designbylaney www.pinterest.com/bylaney 🖨️ My Favorite Print Shop www.printswell.com/a/laney 📋 Try Dubsado https://www.dubsado.com/?c=designbylaney 📋 Try Honeybook http://share.honeybook.com/laney

How to use Bulk Mock-Up | Bulk Mock-Up Images in Photoshop
118 views

Spell out State Names in a Spreadsheet (and more Address List Hacks!)
29 views

Introducing VowProof: New CRM Just for Invitation Designers
76 views

How to Add Names to Wedding Menus: Adobe InDesign Data Merge Tutorial
91 views

How to Create a Realistic Letterpress Effect in Photoshop (Easy Mockup Tutorial)
131 views

Stop Using Layers? 5 Better Selection Tips for Adobe Illustrator
104 views