I have a large excel file that lists words, their grammatical part of speech and definitions. Some of the cell contents look like the following:
sie (pers. ****.) she, her (acc. form of sie [sing.]); they, them (acc. form of sie [pl.]; Sie (pers. ****.) you (formal)
I would like to split the cells into the word(s), part of speech, and definition so that each is in the appropriate column. Alas, the data text to column option won't work. Does anyone have some VB code they could recommend. The file has a couple thousand rows, so this not a line by line task!
sie (pers. ****.) she, her (acc. form of sie [sing.]); they, them (acc. form of sie [pl.]; Sie (pers. ****.) you (formal)
I would like to split the cells into the word(s), part of speech, and definition so that each is in the appropriate column. Alas, the data text to column option won't work. Does anyone have some VB code they could recommend. The file has a couple thousand rows, so this not a line by line task!