in Excel you have to add a column which returns the original data in lower or title case

when the data is in A1

to get lower case in B1 put =LOWER(A1)
to get Title Case in B1 put =PROPER(A1)

if you have multiple columns, or you want Sentence Case
you can export it into a table in Word, change the case and bring it back into Excel.