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, "."))
Yes, with space it's much better.