Pull data from one cell and distribute into two

[rgillson3]

I have a loooong list (2467 rows) of "bad" units of measure that I need to breakdown into a different format for a software conversion.

For instance, I need to take Col C, and break it down into Col's A & B as follows.

[TABLE="width: 375"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bag (58 oz)[/TD]
[TD]Case - 6/58 oz Bag[/TD]
[TD]6/Case - 58 Ounce Bag[/TD]
[/TR]
</tbody>[/TABLE]