Format Text

[Carroll]

Is there a way to format certain cells in a row so that some state
abbreviations, e.g., NM, will have an asterisk appear after the
abbreviation (NM*), but the actual value of the cell will be NM? 10
state abbreviations will have an asterisk after them (NH, NJ, PA, AL,
MI, LA, MO, CO, CA, CA and AK). I can't hardcode the asterisk as these
cells affect the value in other cells, and I need the actual value of
the cell be the abbreviation without the asterisk.

Any ideas?

Thanks,

Carroll Rinehart

 

[Carroll]

Sorry, just found an example. The custom format would be @"*". I can
add the custom format just to those state abbreviations that need it,
and leave the other state abbreviations as they are. I could probably
do some type of conditional format, but this will do.

Thanks anyway,

Carroll Rinehart