Display partial content from a cell

Hello! I am attempting to show part of one cell in another cell. This is the formula I tried but I am getting inconsistent results. I am trying to just show everything after the - in the Author ID column.

Where am I going wrong?

=IFERROR(RIGHT(Contributor@row, FIND("-", Contributor@row) - 1), "")

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

That's because the RIGHT function starts with the rightmost character and counts towards the left, but the FIND function starts with the leftmost character and counts towards the right. You actually have a number of options for this, so let's start here:

=IFERROR(RIGHT(Contributor@row, LEN(Contributor@row) - FIND("-", Contributor@row)), "")

All comments

Paul Newcome

=IFERROR(RIGHT(Contributor@row, LEN(Contributor@row) - FIND("-", Contributor@row)), "")

Jennifer Kaupke

That worked! Thank you so much for your quick reply!

Paul Newcome

Happy to help. 👍️

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.