Use a copy of your data for practice.........
Highlight the column, then do Edit Replace FindWhat: STATE
ReplaceWith: nothing, leave window blank ReplaceAll

Vaya con Dios,
Chuck, CABGx3



"Jorge" wrote:

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...