Hi Mackenzie! I have never found a good way to do this directly in Excel, but I have found a pretty easy workaround with Word. Basically: 1. Copy the title list from Excel and paste into Word 2. Use the Change Case tool in Word to capitalize each word. 3. Use the proofing tools in Word to identify non-significant words that have been capitalized and correct them. 4. Copy the list from Word and paste it into Excel. Nora Weston, MSLS she/her/hers Access & Reference Services Librarian (Contractor) NIEHS Library - Your Partner in Research eleanor.weston_at_nih.gov 984.287.3603 -----Original Message----- From: Mackenzie M. Salisbury <suzanne.salisbury_at_MAIL.WALDENU.EDU> Sent: Monday, June 17, 2019 3:24 PM To: CODE4LIB_at_LISTS.CLIR.ORG Subject: [CODE4LIB] Excel Formula to change Title Fields into APA Format (in terms of Capitalization) Hi all! Does anyone know of an Excel Formula to change Title Fields into APA Format (in terms of Capitalization)? Or a way to make a batch change in another program? I've seen the one off copy and paste website, but nothing that would handle more than one title at a time. Best! Mackenzie Salisbury (she, her, hers)<https://academicguides.waldenu.edu/diversity-inclusion> Librarian, Digital Scholarship Walden University Library<https://academicguides.waldenu.edu/library?utm_source=outlook&utm_medium=email&utm_campaign=email_signature> <https://www.facebook.com/Walden-University-Library> <https://www.facebook.com/Walden-University-Library> <https://www.facebook.com/Walden-University-Library>[icon_facebook]<https://www.facebook.com/Walden-University-Library> <https://www.instagram.com/walden.university.library/> [icon_instagram] <https://www.instagram.com/walden.university.library> <https://twitter.com/WaldenULibrary> [icon_twitter] <https://twitter.com/WaldenULibrary> <https://academicguides.waldenu.edu/library/studentnews?utm_source=outlook&utm_medium=email&utm_campaign=email_signature> [icon_libnews] <https://academicguides.waldenu.edu/library/studentnews?utm_source=outlook&utm_medium=email&utm_campaign=email_signature>Received on Mon Jun 17 2019 - 15:43:17 EDT