ToTitleCase()

This script will come in handy again one day. It simply formats the words in a CSV file to Title Case.

$Loc = C:\Users\BusinessData.csv

$CSVFile = Get-Content $loc -Raw

(Get-Culture).TextInfo.ToTitleCase($csvFile) | Out-File $loc