Is there a similar excel "text to columns"-function in Sharepoint Lists that willto split text content in a cell into several columns?

Question

I have a column in my SharePoint list ("MotherColumn") in which cells contain between 0 and 5 text statements: ("strategy1","strategy2","strategy3","strategy4","0 strategy"). Can I split this text into five corresponding "daughter columns" (e.g.: "Strategy 1","Strategy 2","Strategy 3","Strategy 4","No strategy") where the content is replaced by "yes" or "no" corresponding the content from the "mother-column" - like the "text to columns" in Excel. Sample:

Any ideas will be most helpful :-) KR Christian

Answer 1

Hi @ chasman ,

You can achieve this by creating a Calculated column (calculation based on "MotherColumn" column): display "Yes" or "No" corresponding to the content in the "MotherColumn" in the corresponding column.

Here are steps：

1.Create a Calculated column(named Strategy 1)

2.Enter the following formula:

=IF(ISERROR(FIND("Strategy 1",MotherColumn)),"No","Yes")

This step needs to be repeated five times for the five corresponding "daughter columns".

The final display effect is shown in the figure below:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.