Mcygee
03-12-2009, 01:50 PM
Sorry for my ignorance, but I'm learning. If anybody knows of a solution posted elsewhere please direct me there because I couldn't find it. Here is what I need to know how to do...
I need to take comma delimited column like this....
----------< A >
<1> Math, B4, Chris Able
and place each entry into the column I want. I want to make it look like this (substituting dashes for spaces due to the formatting of the forums)...
------------< A > -------< B >---------- < C > -----------< D >
<1> -------------------Chris Able --------Math -------------B4
Then this macro will repeat down as many rows as there is data until no more rows are left.
I'm not asking for anybody to write this thing out for me, but what I'm looking for is the string I need to pull the data separately between each comma and then place it where I want and then repeat until there's no more rows.
I would really appreciate any help I can get on this. Even if it's just a nudge in the right direction.
THANKS!
I need to take comma delimited column like this....
----------< A >
<1> Math, B4, Chris Able
and place each entry into the column I want. I want to make it look like this (substituting dashes for spaces due to the formatting of the forums)...
------------< A > -------< B >---------- < C > -----------< D >
<1> -------------------Chris Able --------Math -------------B4
Then this macro will repeat down as many rows as there is data until no more rows are left.
I'm not asking for anybody to write this thing out for me, but what I'm looking for is the string I need to pull the data separately between each comma and then place it where I want and then repeat until there's no more rows.
I would really appreciate any help I can get on this. Even if it's just a nudge in the right direction.
THANKS!