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), "")
Best Answer
-
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)), "")
Answers
-
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)), "")
-
That worked! Thank you so much for your quick reply!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives