Change Case in a column

[Joe]

i have a sheet with multiple columns.

on one column i have a mix of upper case, proper case and lower case cells.l
uppercase.

i need to be able to change the case of words is larger than 5 characters to
lower case in this column. i don't want to change any of the Proper case
cells.

any suggestions?

 

[Billy Liddel]

Joe

You will need a helper column. you can then paste the values over the
original data.
Assuming that the column is A use:

=IF(EXACT(A2,PROPER(A2)),A2,IF(LEN(A2)<=5,A2,UPPER(A2)))

However note:

Going for a Song GOING FOR A SONG
christmas carol CHRISTMAS CAROL
Going For A Song Going For A Song

the first Going for a song is not fully Proper so converts to Upper.

Peter Atherton

 

[Don Guillett]

Sub changecaseif()
mc = "c"
For i = 1 To Cells(rows.Count, mc).End(xlUp).Row
If Len(Cells(i, mc)) > 5 Then Cells(i, mc) = LCase(Cells(i, mc))
Next i
End Sub