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

Cleaning up a massive address list doesn't have to take all day! 💌 In this video, I’m sharing my favorite shortcuts for spelling out state abbreviations, fixing weird capitalization, and restoring those pesky missing zeros in zip codes. Whether you want to do it manually with my "Find and Replace" tricks or use an automatic extension to do it in seconds, I’ve got you covered. Key Highlights: 📍 Smart Find & Replace: How to batch-change abbreviations without accidentally ruining other words. ⚡ Automatic Cleanup: A walkthrough of the Address Cleanup Extension that standardizes street names (Lane, Drive, etc.) and apartment labels instantly. 🔢 The "Zip Code" Fix: How to bring back leading zeros for New England addresses that Google Sheets likes to drop. ✍️ Standardized Capitalization: How to fix messy names and cities so they look professional on your envelopes. Links & Resources Mentioned: 🛠️ Address Cleanup Extension: Get the tool I used to automate this whole process here: https://designbylaney.com/address-cleanup 📄 Free Address Template: Grab my preferred spreadsheet layout for wedding stationers: https://designbylaney.com/addresstemplate ~ 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