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 Wed Jun 19 2019 - 14:16:02 EDT