Formatting after Importing
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 |
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 |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com