how do i remove a portion of data from a column

S

SynAtl

I have a column with City, State, Country in the cells.....I am trying to
"extricate" the information into 3 separate columns.....any ideas? I am sure
that this is simple for someone and I am just unable to find the answer when
I search.

Thanks!
 
S

SteveF

I have a column with City, State, Country in the cells.....I am trying to
"extricate" the information into 3 separate columns.....any ideas? I am sure
that this is simple for someone and I am just unable to find the answer when
I search.

Thanks!
Click to expand...

If the data is separated by commas you can use the Data-Text-to-Colums
feature- just make sure you have 2 blank columns to the right of the
column that has the data before you start
 
T

Toppers

How is the data delimited? Look at Data ==>"Text to Columns" to see if this
is an option.
 
Top