Separating data

[cejones11]

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.

[daddylonglegs]

If the data is in A1 try

=LEFT(A1,FIND(",",A1)-1)

[cejones11]

It worked great! Thank you.