How do I get just the first 4 characters to the left of the text string (2700-insurance)

JOIN(COLLECT([2700 & 5090 Codes]@row:[6000 Codes]@row, [2700 & 5090 Codes]@row:[6000 Codes]@row, @cell <> ""), ", ")

I need to get the first 4 numbers to the Left of the text string from each of the columns and output to another column. there are 9 columns that I will be collecting from.

Thanks for any help

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You would have to use a LEFT function on each individual cell and then add those together.

=LEFT([Column1]@row, 4) + ", " + LEFT([Column2]@row, 4)

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.