In cell F2, use a FIND function embedded in a LEFT function to extract the city from cell E2. The city value in E2 is the text before the first comma. The FIND function locates the position of the comma in E2 text. The LEFT function extracts the characters from 1 to the position before the comma.