Capitalize the last character of a cell.

[oobe]

I have a huge amount of cells where the city and state are combined.
For example Los Angeles, CA. The problem is the text comes over as LOS
ANGELES, CA and when I use the proper function it comes out to Los
Angeles, Ca. All I need to do is figure out how to capitalize the last
character in each of these cells without having to do go city by city.
Any ideas?

 

[Dave Peterson]

Maybe you can use a helper cell with a formula like:

=PROPER(LEFT(A1,LEN(A1)-2))&UPPER(RIGHT(A1,2))

 

[oobe]

Thanks a million!!!! =]