I need a formula to separate out the city names in a concatenated cell. Examples are below.
In column A row 2 & 3.
The city name will always be after a dash.
I need in column N "ALABASTER", column O "IRVING"
colunmn N "ATLANTA", column O "JACKSONVILLE"
Can anyone help?