Evaluating a string of text

[Marc Enzi]

I have to evaluate AIrport Codes and determine if the Airport is in the Continental USdomestic CONUS or outside the Continental US (OCONUS).

US Airports all start with K and Airports outside the US start with some letter other than K.

So I have two columns

Column G.......Column H
ICAO..............O/C
KLAX...............C............Los Angeles
PHNL...............O...........Honolulu

I want the formula in Column H to evaluate the 4 letter code and if it starts with "K", return "C", and if it starts with anything other than "K" return "O".

Thanks

 

[NBVC]

Try:

=If(left(G2,1)="K","C","O"), copied down

 

[Marc Enzi]

Brilliant

You people are a treasure.

Thanks