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 here
Owner: John Doe
Objective: pull as much data as possible
How 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)
Assuming you have few line breaks as separator and assuming you are on Windows
- select entire column with texts
- Data -> Text to Columns
- on second step check Other and enter in the box to the right Ctrl+J. Check as well Treat consecutive delimiters as one
- Finish
