Capitalize the last character of a cell.
 

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?

Capitalize the last character of a cell.
 

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

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



oobe wrote:

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

Capitalize the last character of a cell.
 

Thanks a million!!!! =]