Random case, the Comic Sans of case conversion options...
On Fri, Jun 21, 2019 at 5:01 PM Lolis, John <jlolis_at_whiteplainsny.gov>
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 <
> 0000001fd0f2bb98-dmarc-request_at_lists.clir.org> 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
> > kndeibel_at_syr.edu
> > 222 Waverly Ave., Syracuse, NY 13244
> > Syracuse University
> >
> > -----Original Message-----
> > From: Code for Libraries <CODE4LIB_at_LISTS.CLIR.ORG> On Behalf Of
> Mackenzie
> > M. Salisbury
> > 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 Sat Jun 22 2019 - 08:48:21 EDT