Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
Capitalize text when input in cell | Excel Discussion (Misc queries) | |||
capitalize first letter automatically when typing in excel cell | Excel Discussion (Misc queries) | |||
Capitalize | Excel Discussion (Misc queries) | |||
Capitalize first letter when type a name in each cell. | Excel Worksheet Functions |