Every month I have to create some recurring reports. I am using macros to do most of the leg work, but I am still having an issue when doing data cleanup.
I receive the data in the format like this:
As part of how the reports have to look like the name information goes into colum A, the volume data goes into column B, and the location code goes into column C.lastname, firstname/LocationCode 123,123,123
Example for John Doe from Seattle:
Doe, John/SEA 123,123,123
I can separate the name and data into the 2 columns when importing the CSV data, but how can I separate the location code "/SEA" from the name and dump into its own column?Example
Column A Column B Column C
Doe, John 123,123,123 SEA
Any help would be welcome.
Thanks.
Chris
Bookmarks