Display partial content from a cell

Jennifer Kaupke

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), "")

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)), "")

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)), "")

Jennifer Kaupke

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

Paul Newcome

Happy to help. 👍️