Let us also not forget that venerable editor, Notepad++, which has eight different case conversion options, including sentence case and "blend" case conversion selections (whatever that does). buT wHy WoUlD ANyoNe wanT tO usE rANdom cASe? John Lolis Coordinator of Computer Systems 100 Martine Avenue White Plains, NY 10601 tel: 1.914.422.1497 fax: 1.914.422.1452 https://whiteplainslibrary.org/ *When you think about it, *all* security is ultimately security by ignorance.* On Wed, 19 Jun 2019 at 14:12, Kate Deibel < [log in to unmask]> wrote: > 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 > [log in to unmask] > 222 Waverly Ave., Syracuse, NY 13244 > Syracuse University > > -----Original Message----- > From: Code for Libraries <[log in to unmask]> On Behalf Of Mackenzie > M. Salisbury > Sent: Monday, June 17, 2019 3:24 PM > To: [log in to unmask] > 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 > > >