Here's an interesting one: I have a list where one text column accepts multiple delimited values. (By that, I mean multiple values separated by delimiters.) Is there a calculated feature where I can take each value and put it in its own column? For example, if I had the values " a,b,c,d,e," in the text column, and five other columns that could accept the values separately - Is this a possibility?

1 Answer 1


You can use FIND() function in the calculated column split the value.

Here is a similar post for your reference:

Split a text based on delimiter and add items to a sharepoint list using SPD workflow

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.