The formula examines the last digits that accompany the text string and then looks for the city code the precedes it.
Using COUNTIF to count for text contained in a string
Understanding INDIRECT() formula in MS Excel
How to extract only capital letters to different cells
Returns a specific number of characters from a text string starting at the position you specify
MID(text, start_num, num_chars)
Specifies a logical test to perform
IF(Something is True, then do something, otherwise do something else)
Returns TRUE if the value is a number
Returns the rightmost characters from a text value
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM