Can I separate two words in a column?
 

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

Can I separate two words in a column?
 

Use 'Text to Column' feature under Data.


"Jorge" wrote in message
...
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...

Can I separate two words in a column?
 

data text to column

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jorge" escreveu:

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

Can I separate two words in a column?
 

If you just want to get rid of that word State...

Select the range (entire column???)
edit|replace
what: State_ (State followed by a space character)
with: (leave blank)
replace all



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

--

Dave Peterson

Can I separate two words in a column?
 

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