In a SharePoint List column A, I have a avalue like:

xx|[email protected]":yy|[email protected]":

In a calculated column, I want to get email IDs with separated by a semicolon, like:

[email protected];[email protected]

Basically I want to get a string between | & :


1 Answer 1


You are limited by the Functions you can use in SP, there is no .split() function

See: https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List

You can test/develop in Excel, then copy paste your Formula to SP

PS. copy/paste that site, It will be gone 1/1/2018


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.