MID(...)
Find the two characters representing US City in a string
Used Functions
Category: Text
Returns a specific number of characters from a text string starting at the position you specify
Syntax
MID(text, start_num, num_chars)
Practice MID Formula at Sheetzoom
MID formula at Microsoft helpCategory: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Category: Information
Returns TRUE if the value is a number
Syntax
ISNUMBER(value)
Category: Text
Returns the rightmost characters from a text value
Syntax
RIGHT(text,[num_chars])
0
The formula examines the last digits that accompany the text string and then looks for the city code the precedes it.