Counting by numbers of Characters in a cell
What is the formula to sort by number of characters in a cell?
I work for an airline and we have domestic and international flights. I'm trying to sort or conditional format rows by identifly international flights.
Domestic flights have 3 letters or number identifiers
International flights have 4 letters or number identifiers
I have two columns which will have airport codes., departure and arrival I'm looking to to find international airport codes (with 4 characters or more).
Departure Arrival
1 PNS RSW
2 CYYJ OAK
3 ASE CYEG
I would need it to sort and rows of data containing an international airport
codes.
The results being row 2 and 3.
Also, can I highlight certain international codes a certain color?
thanks
Michelle
|