Get rid of extra Characters in Checkbox selected

+3

I have a checkbox list field and I am trying to fetch the value of the selected fields without any extra characters

eg. I am selected Application access but the value is 3;#Application Access.

I used this formula (subString(Location,3,(length(Location)-1))) for Location and It worked fine, but I is not working for Checkbox.

Thanks for all the help.

+5

try the parselookup function.
parselookup(Checkbox_NamedControl)

Sign up