Can I separate two words in a column?

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

Marcelo

data > text to column

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



"Jorge" escreveu:
 
C

CLR

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
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a macro to eliminate certain words from several columns 4
Finding the number of times a word is used in a range of cells 8
Two columns followed by single page-width column on same page 0
Excel 2007: Vlookup Problem 5
Separating data from cells 9
Sorting "State" Column onto separate worksheets in same workbook. 2
Userform to query? 3
How to print two a6 booklets (A5 unfolded) on A4 paper? 3

Top