Splitting text in cells.

Try this
Enter formula in B1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B
1	Sentence 1. Sentence 2? Sentence 3!	Sentence 1.
2	Sentence 4.	Sentence 2?
3		Sentence 3!
4		Sentence 4.

Nice formula Al,

Let me add simple (easy to read, understand and modify, but not quick for longer datasets) VBA solution, as the question was published in programming/VBA/macros subforum:

Please Login or Register  to view this content.

Well, it works on your sample:

Please Login or Register  to view this content.

Why not

Please Login or Register  to view this content.

Thank you for your effort, guys, but NONE of the above work.

AlKey
I don't need a formula. The replacement should happen in the same column starting with the same cell (first sentence should remain in the selected cell with all other sentences moved to the cells created for them below).

Kaper, PCI
Your code splits cells below the selected cell as well.

Mr.PB
Your code discards everything after the 256th character.

xladept
Your code does nothing with the selected cell but splits the one below and corrupts it into the bargain.

Perhaps can you try the last update done in my code
Keep in mind to adjust the list of chararcters to use => Chlst

Please Login or Register  to view this content.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

xladept

Take any text (newspaper article, novel, anything). Paste a paragraph each into cells A1:A10 or any other range. I need a script that would split text in ANY selected cell into sentences (ending in .?! minus all leading & trailing spaces) without affecting ANY other neighboring cells... What need is there to upload a sample workbook?

This requires that you select the first cell:

Please Login or Register  to view this content.

... What need is there to upload a sample workbook?

Why are you asking for members to provide their own sample data and the solution?

Want to get your question answered quickly?

• Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
• On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
• Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
• Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
  
• Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

Violation removed. I was responding to a report, but missed the link in the first post. My apologies.