This seems like a fairly simple operation, but I don't know how to do it. I have two spreadsheets, each of which has labeled columns with data from newspaper entries. For the most part, the new spreadsheet that I want to transfer data into is just like the old one but with the column categories moved around.

However, in a few cases, the old spreadsheet has information in one column that the new spreadsheet will have in two. For instance, the old spreadsheet puts a location in one column in the format "village, district" whereas the new spreadsheet simply has one column for village, and one for district. Is there any way to tell Excel to put whatever is before the comma on the old spreadsheet (the village) in one column in the new spreadsheet, and whatever is after the comma (the district) in another column in the new spreadsheet?

I figure this is possible with a fairly simply script. Thanks a lot for any help you can give me.