Forum Discussion
Extracting sentences from a cell
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, "."))
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, "."))
@HansVogelaar I have a similar situation and the formula does not seem to work and not sure there is one that could work. I have info in excel cells within a sheet that are separated by returns, sometimes 2 - 4 in each cell:
Example:
Description: the info goes hereOwner: John Doe
Objective: pull as much data as possibleHow can I extract the data from each cell into columns (Description, owner, etc.)?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar let me know if you can see the image containing M2 from my sheet. Goal, to see if I can extract the 4 items into 4 separate columns (Description, Primsry Obj., Audiences, Owner)
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. 🙏🏼
Yes, with space it's much better.
- i need help
Why don't you start new discussion here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral and explain what is your question.
