Hi Mackenzie!

I have never found a good way to do this directly in Excel, but I have found a pretty easy workaround with Word. Basically:

1. Copy the title list from Excel and paste into Word
2. Use the Change Case tool in Word to capitalize each word.
3. Use the proofing tools in Word to identify non-significant words that have been capitalized and correct them.
4. Copy the list from Word and paste it into Excel.


Nora Weston, MSLS
she/her/hers
Access & Reference Services Librarian (Contractor)
NIEHS Library - Your Partner in Research
[log in to unmask]
984.287.3603



-----Original Message-----
From: Mackenzie M. Salisbury <[log in to unmask]> 
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>