I need your assistance please on a formula which will extract all the characters from the left (of a string) with the exception of the two right characters with a preceeding space. An example of the data is below:
Mount Laurel Nj
Seattle Wa
Waco Tx
Fort Worth Tx
Earth City Mo
Charlotte Nc
Sparks Md
Northbrook Il
Plano Tx
Rochester Ny
Van Nuys Ca
Tulsa Ok
Expecting the following output:
Mount Laurel
Seattle
Waco
Fort Worth
Earth City
Charlotte
Sparks
Northbrook
Plano
Rochester
Van Nuys
Tulsa
Your assistance is greatly appreciated.
Bookmarks