how do i remove a portion of data from a column
 

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!

how do i remove a portion of data from a column
 

On Mar 15, 2:23 pm, SynAtl wrote:
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!

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

how do i remove a portion of data from a column
 

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

"SynAtl" wrote:

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!