I get data in the form of a csv file and I need to change one field
that that looks like this:

Col C (for example)

MORNING/EST
AFTERNOON/PACIFIC
WEEKEND/MST

I would like to break the cells into 2 different col one for time
(morning/afternoon, etc) and one for time zone (est, pacific, mst)

So I guess I need to count over to the / then take the timezone info
and pass it through a series of case statements, est = estern, mst =
mountain, and then put that into a new colunm.

I need to make this available whenever I open the file and not have to
recreate the code everything I get a new file.

Thanks for any help

Try DataText to Columns delimited by other.

Enter the / mark and Finish.

Make sure you have an empty column to the right of column C.

Record a macro whilst doing this operation.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 16:47:02 -0700, wrote:

I get data in the form of a csv file and I need to change one field
that that looks like this:

Col C (for example)

MORNING/EST
AFTERNOON/PACIFIC
WEEKEND/MST

I would like to break the cells into 2 different col one for time
(morning/afternoon, etc) and one for time zone (est, pacific, mst)

So I guess I need to count over to the / then take the timezone info
and pass it through a series of case statements, est = estern, mst =
mountain, and then put that into a new colunm.

I need to make this available whenever I open the file and not have to
recreate the code everything I get a new file.

Thanks for any help