I have a list lookup control dropdown at the top of my form with its ID connected to a single line text site column and the list connected to a sharepoint list. Later in the form, I have a calculated value control where I want to display the selected dropdown value from the lookup control at the top of the form. In the calculated value control I have the formula set as the named control of the list lookup column. The issue I am running into is that the calculated value field is displaying the selected drop-down but with "1;#" or "2;#" in front of it. Is there a way to get rid of that?

I am having a similar problem with people or group fields that I want to be displayed later in the form through a calculated value control