Not sure what the original casing looks like, but Excel does have the PROPER() function that capitalizes the first letter of each word. To do more, you're going to need a custom function. Plus, you're always going to run into edge cases like words that that meant to be in all caps like IBM or partially all caps like FRBRization. I can think of some heuristic approaches that one could do in VBA. I kinda wish I had time to code this up.
Katherine Deibel | PhD Inclusion & Accessibility Librarian Syracuse University Libraries T 315.443.7178 [email protected] 222 Waverly Ave., Syracuse, NY 13244 Syracuse University -----Original Message----- From: Code for Libraries <[email protected]> On Behalf Of Mackenzie M. Salisbury Sent: Monday, June 17, 2019 3:24 PM To: [email protected] 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>
