I found this via Google, and haven't tested it yet, but it sounds
reasonable if a little convoluted.

https://www.dummies.com/software/microsoft-office/excel/how-to-set-text-to-sentence-case-with-an-excel-formula/

It won't deal with proper nouns that SHOULD be capitalized.

On Mon, Jun 17, 2019 at 3:23 PM Mackenzie M. Salisbury
<[log in to unmask]> wrote:
>
> 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>



-- 
Debbie