I have a series of Drop Down lists linked to another SharePoint List. The select of the "2. Select Sub-Program" is then required to hide or display other panels. The issue I have is that the actual returned value e.g. 6;#Communication (Stakeholder) is not what is displayed in the list. I tried by using substring BUT becuase the prefix value is comes 1 chr (6;#) and then in other cases "14;#" I cannot return the value I need.
Is there any formula similar to substring after that will allow me to return the values after the #/