Formula result can't be copied and pasted correctly

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.