Can I separate two words in a column?

  • Thread starter Thread starter Jorge
  • Start date Start date
J

Jorge

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...
 
data > text to column

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



"Jorge" escreveu:
 
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
 
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
 
Back
Top