Hi,

I have 2 columns with data I need to split up. One column contains first
and last names. I need that into 2 columns, first in one, last in another.

The other column of data has City ST Zip. There are no commas or periods.
I need that split into 3 columns.

I need help with a formula to do that.

Thank you!!!