Forum Discussion
Solved
Extracting sentences from a cell
Hi. I have a cell full of sentences. I need to extract each sentence into new adjacent cells. Thank you.
Does each sentence end in a full stop (point)? If so, you could use Data > Text to Columns, with . as delimiter.
If you have Microsoft 365, you can use a formula:
=TRIM(TEXTSPLIT(A1, "."))
This is excellent! Thank you. Would you happen to know how to make them populate adjacent rows as opposed to columns???
The TEXTSPLIT formula would be
=TRIM(TEXTSPLIT(A1, , ". "))
(Note the extra comma)
For older versions of Excel, there is no really easy method, as far as I know. You could use Text to Columns, then copy the result and paste/transpose it, or use the TRANSPOSE function...
- Thank you. 🙏🏼