I've created a workflow which auto-generates an email. I'm using "Add or change lookup" to provide information to the "To:" line and to the body of the email (e.g. [%Current Item: Name%]).
It works well enough but what is showing up in the email is "27;#Name".
The source for the data is a lookup column so I'm thinking it's a reference between the two fields; You look up the building# which also returns the name of the person responsible for that building.
I'd like to know if I'm correct - that the characters "27;#" are because it is from a lookup column and a related column.
How do I get rid of the characters?