thedrizzle
New Member
- Joined
- Oct 8, 2018
- Messages
- 5
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:
<colgroup><col></colgroup><tbody>
</tbody>
CHICOPEE, MA TO Rocky Mount, NC |
MCDONOUGH, GA TO ROCKY MOUNT, NC |
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? |
<colgroup><col></colgroup><tbody>
</tbody>