Thread
:
Formatting after Importing
View Single Post
#
2
Posted to microsoft.public.excel.programming
Gord Dibben
external usenet poster
Posts: 22,906
Formatting after Importing
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben