knowledgetrans
New Member
- Joined
- Jul 22, 2016
- Messages
- 6
Dear Experts,
I wish to know how can I split a paragraph in different cells - one below the other. Catch is when a sentence ends with a full stop and space, question mark, punctuation mark or tab, the next line should appear in next cell. Also, the numbering should be altered as shown in attached example. Also, third column, if having any text, should also be split.
Please suggest how this can be done!
the entire case has been described in excel... please check the excel uploaded at [TABLE="class: cms_table, width: 100%"]
<tbody>[TR]
[TD]Download link
https://we.tl/ILbiil8qjs [/TD]
[/TR]
</tbody>[/TABLE]
I think you will have some doubts. Please feel free to ask.
In the final result, we need to do the following.
1. Break cells in Column A and C - this you have done before.
2. Work on numbering in Column B - this also has been done by you.
3. We need the colour also copied in Column B
4. We need to remove duplicates in Column A -> but catch is that sequence of colours should be Golden, Green and Grey cells at bottom.
5. Need to calculate word count basis the 'colour of column B' and 'word count of column A'
6. DNT terms to be highlighted in RED
7. Glossary Terms should appear as in the example.
Will be grateful if you can help with macro.
Regards,
Rahul
I wish to know how can I split a paragraph in different cells - one below the other. Catch is when a sentence ends with a full stop and space, question mark, punctuation mark or tab, the next line should appear in next cell. Also, the numbering should be altered as shown in attached example. Also, third column, if having any text, should also be split.
Please suggest how this can be done!
the entire case has been described in excel... please check the excel uploaded at [TABLE="class: cms_table, width: 100%"]
<tbody>[TR]
[TD]Download link
https://we.tl/ILbiil8qjs [/TD]
[/TR]
</tbody>[/TABLE]
I think you will have some doubts. Please feel free to ask.
In the final result, we need to do the following.
1. Break cells in Column A and C - this you have done before.
2. Work on numbering in Column B - this also has been done by you.
3. We need the colour also copied in Column B
4. We need to remove duplicates in Column A -> but catch is that sequence of colours should be Golden, Green and Grey cells at bottom.
5. Need to calculate word count basis the 'colour of column B' and 'word count of column A'
6. DNT terms to be highlighted in RED
7. Glossary Terms should appear as in the example.
Will be grateful if you can help with macro.
Regards,
Rahul
