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 <[email protected]> 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
