Random case, the Comic Sans of case conversion options...
On Fri, Jun 21, 2019 at 5:01 PM Lolis, John
wrote:
> Let us also not forget that venerable editor, Notepad++, which has eight
> different case conversion options, including sentence case and "blend" case
> conversion selections
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
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
OpenRefine will allow you to change case in two clicks:
https://guides.library.illinois.edu/openrefine/commontransform
If you have very specific rules you want to follow you could also create a
custom transform.
Hope that helps (let me know if you'd like help with writing a GREL if you need
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
This probably isn't helpful, but I would do this in Pandas with python:
```
import pandas as pd
def apa_book_title(row):
titles = row['Title'].split(':', maxsplit=1)
formatted = []
for title in titles:
title = title.strip()
title = title[0].upper() +
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
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
