In an adjacent column you can use this formula:

=LOWER(A1)

assuming your data to be in column A, and then copy this formula down. Then you can fix the values and either delete column A or copy/paste the column B values into column A and then delete column B.

Hope this helps.

Pete