How can I separate data in a cell?
"Nashville, TN" appears in a single cell. I want to pull Nashville out in a separate cell.

Is there a formula that can help me? Thanks in advance for any help you can offer me.