Formula result can't be copied and pasted correctly

JYATES

I am using a formula that takes the value from several columns to generate a job name and number. It works beautifully but for some reason, it's putting a space after each "_" and so I have to use "wrap text" to display appropriately. However, we used to be able to copy the job name generated and paste into another document and it would paste appropriately but instead, it is putting in spaces so the name looks like before text wrapping. I have tried to remove any spaces in the formula but it's not doing anything. How can I fix this?

Current column formula: = [Department]@row + "_" + [Audience]@row + "_" + [Type]@row + "_" + [Description]@row + "_" + RIGHT(YEAR([Created]@row), 2) + "-" + [Job Number]@row

Adam Murphy

Not sure why spaces are being added but you could wrap your formula in a SUBSTITUTE function to replace any spaces with "" and see if that helps.