Re: Excel Formula to change Title Fields into APA Format (in terms of Capitalization)

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
> >
>