I want to separate the following:

State Florida
State New York
State Georgia
State Kansas
Etc...

I want to be able to tell Excell to separate the word State and put it alone
in another column or elimante it altogether and leave in another column the
name of the state. Any ideas?

Thank you again...