By default, the values of a multi-select field is presented as a single row in a saved search and are separated by a comma. My custom multi-select field is sourced from the Contact list. The format of our Contact is Last Name first before First Name. As such, the result is like this:,
Smith, John,Alvarez, Mary Grace (for John Smith and Mary Grace Alvarez)
I've got to change the separator from a comma to a semicolon. I did the Replace function which obviously does not work because there are commas to separate the first name and last name.
Is there a way to change the separator to semicolon?