View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michelle michelle is offline
external usenet poster
 
Posts: 310
Default 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