-
Convert Text to cells Sentences by Punctuation Marks
Hello
I want to divide the texts I have into sentences according to punctuation marks. Each sentence will be written in a separate cell. For example, these are punctuation marks (.) (…) (!) (?). But I can add and remove later. And "TextToColumns" not working good.
text before
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse eget felis eget elit euismod dignissim a a felis... Ut imperdiet justo condimentum risus consequat facilisis? In hac habitasse platea dictumst! Integer eget ex faucibus, varius libero in, rhoncus mauris. Sed a posuere purus... Maecenas tincidunt enim sodales, blandit nunc a, pellentesque lorem. Proin dapibus ultricies ultricies. In pellentesque lectus quis dolor ultrices ultrices.
text after
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Suspendisse eget felis eget elit euismod dignissim a a felis...
Ut imperdiet justo condimentum risus consequat facilisis?
In hac habitasse platea dictumst!
Integer eget ex faucibus, varius libero in, rhoncus mauris.
Sed a posuere purus...
Maecenas tincidunt enim sodales, blandit nunc a, pellentesque lorem.
Proin dapibus ultricies ultricies.
In pellentesque lectus quis dolor ultrices ultrices.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules