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!
