Separate a column by commas

[jamesv32]

I have data in this format​

<TBODY>
[TD="width: 50%"]

Item #​

​

​

​

​

[/TD]
[TD="width: 50%"]

Data​

​

​

​

​

[/TD]

[TD="width: 50%"]

A​

​

​

​

​

[/TD]
[TD="width: 50%"]

1, 2, 3, 4, 5​

​

​

​

​

[/TD]

</TBODY>

And I am trying to see if there is a way to separate the data column into separate colums anywhere that a comma is present.Need data to look like this.​

<TBODY>
[TD="width: 17%"]

Item #​

​

​

​

​

[/TD]
[TD="width: 17%"]

Data​

​

​

​

​

[/TD]
[TD="width: 17%"]

Data​

​

​

​

​

[/TD]
[TD="width: 17%"]

Data​

​

​

​

​

[/TD]
[TD="width: 17%"]

Data​

​

​

​

​

[/TD]
[TD="width: 17%"]

Data​

​

​

​

​

[/TD]

[TD="width: 17%"]

A​

​

​

​

​

[/TD]
[TD="width: 17%"]

1​

​

​

​

​

[/TD]
[TD="width: 17%"]

2​

​

​

​

​

[/TD]
[TD="width: 17%"]

3​

​

​

​

​

[/TD]
[TD="width: 17%"]

4​

​

​

​

​

[/TD]
[TD="width: 17%"]

5​

​

​

​

​

[/TD]

</TBODY>

Any help would be greatly appreciated.



​

 

[General Ledger]

Use Excel's Test to Columns feature to separate the data into separate cells.
Step 1: Choose Delimited rather than Fixed width
Step 2: Check box for Comma
Step 3: Finish

 

[Rick Rothstein]

Use Excel's Test to Columns feature to separate the data into separate cells.
Step 1: Choose Delimited rather than Fixed width
Step 2: Check box for Comma
Step 3: Finish

The OP's data looks to be delimited by a comma and a space, so in addition to checking the Comma checkbox, I would also check the Space checkbox as well... and make sure the "Treat consecutive delimiter as one" checkbox is checked as well.