Micro help?

Closed
Fool - Feb 25, 2010 at 03:38 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 25, 2010 at 06:31 PM
Hey guys,
I'm running Excel '07, and I'm stuck doing data entry on something which can be simplified greatly with the help of a micro. Maybe one of y'all can help?

Pretty much, I've got data coming into me as follows:
Chicken, W. - WE444 AA - Deliciousness, Yum Yum
Chicken, D. - XX432 B4 - Almost as delicious!

And what I'm looking to do is separate the data into colums as follows:
D | Chicken | XX | 432 | B4 | Almost as delicious!

Is this possible? Would someone kindly mind throwing some code up to help in this task?

Thank you so much for any help.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 25, 2010 at 06:31 PM
You have not mention if it is a delimited file or a fixed length file. Could you put a sample file at a share site like https://authentification.site
0