Display partial content from a cell

Options

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



Tags:

Best Answer

Answers