Random case, the Comic Sans of case conversion options... On Fri, Jun 21, 2019 at 5:01 PM Lolis, John <[log in to unmask]> wrote: > 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 > > > > > >