Moving some text to the next cell

[thedrizzle]

Hi all, I've got a large data set (roughly 1,500 cells) that I need to split out. They are currently formatted like this:

[TABLE="width: 410"]
<colgroup><col></colgroup><tbody>[TR]
[TD]CHICOPEE, MA TO Rocky Mount, NC[/TD]
[/TR]
[TR]
[TD]MCDONOUGH, GA TO ROCKY MOUNT, NC[/TD]
[/TR]
[TR]
[TD]ATLANTA, GA TO ORLANDO, FL

I'm trying to separate this into four cells - City, St, City, St. Each cell is split in half with the word "TO", but I can't figure out how to separate everything after the word "TO" into the next cell since they're all different lengths. Once I do separate them, I can use the delimiter on the comma to separate each city from its state.

Anybody know how to do this?[/TD]
[/TR]
</tbody>[/TABLE]

 

[thedrizzle]

Ah very true, for some reason my brain was thinking it would make it easier, but you're right. I'll go back and do it that way to clean up the leading spaces too. Thanks again for the help.

 

[Peter_SSs]

Cheers. No problem.