A room list arrives in uppercase. PROPER turns WEST MEETING ROOM into West Meeting Room, which is useful for a printed directory. It also turns AV ROOM into Av Room. Keep a place to specify the spelling you actually want.

PROPER turns WEST MEETING ROOM into West Meeting Room and AV ROOM into Av Room.

Illustrated label proof. Check acronyms before printing.

Give known exceptions their own column

Keep the source in column A. In column B, add the approved spelling only where you need it, for example AV Room. In C2, enter the formula and fill it down:

=IF(B2<>"",B2,PROPER(A2))

Use an empty B cell for the normal rule. A cell with spaces counts as text, so clear it when it is meant to be empty.

Check one normal row and one exception

The directory output should show West Meeting Room and AV Room. Check initials, brand names and names with punctuation too. Once the proof is approved, use the display column for the directory and keep the source plus overrides so you can regenerate it.

An override cell with AV Room takes precedence over the automatic capitalization.

Illustrated output. The source names remain available for another pass.

Microsoft’s Excel function reference