|  | Change Case in a column | | |
| | | Joe |  |
|  Posted: Wed Aug 13, 2008 4:22 am Post subject: Change Case in a column |  |
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 | |
| | Posted: Wed Aug 13, 2008 7:21 am Post subject: RE: Change Case in a column | |
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
"Joe" wrote:
| Quote: | 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? |
|
| |
| | | Don Guillett | |
| | Posted: Wed Aug 13, 2008 10:08 am Post subject: Re: Change Case in a column | |
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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Joe" <Joe@discussions.microsoft.com> wrote in message
news:C43840C2-DEBF-4E93-B4CE-9A79BF70B42A@microsoft.com...
| Quote: | 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? |
|
| |
|
|
