Split Words in the comment text - VBA Macro : I am trying to write a macro which will split the comment. My supervisor wants to prioritize the comments for eg: 

Low : Comment 1

Medium : Comment 2

High: Comment 3

The out put should be displayed in an excel with the following headings
I was able to write a macro to export comments from words to an excel file. However, I am struggling to add this code snippet to split the comment text

Comment ID	|Page|	Section/Paragraph Name	|Comment Scope	|Comment text	|Priority	|Reviewer	|Comment Date|
1	|1|	1.1heading1|	example| heading|	Comment 1	|Low	|BlueDolphin	|1/1/1|
2|	2|	1.2heading	|example2	|Comment 2	|Medium|	BlueDolphin|	1/1/1|
3|	3	|1.3heading|	3example3|Comment 3	|High	|BlueDolphin	|1/1/1|


Anyhelp is much appreciated

Thanks

BlueDolphin
