Currently, I am working on a column with the content for teacher's comment.
I would like to delimit it by the space or comma or punctuation marks between words inside the content.
At the same time, I would like to take out each of the words in the content and then place them into rows instead of columns .
Catherine is a good girl . -> This is the teacher's comment.
After delimit in excel, I have "Catherine is a good girl . " in 6 columns with 1 column for 1 word.
However, I would like the outcome of the words to be placed into rows. It would look like this, in 6 rows:
Catherine is a good girl .