| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Capitalize the last character of a cell.
Thanks a million!!!! =]
|
| Reply |
| 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 | |||
Linear Mode
