Excel formula to keep text after a character

Extract only the text after a symbol.

=SE.ERRORE(DESTRA(A2;LUNGHEZZA(A2)-TROVA("_";A2));A2)

=IFERROR(RIGHT(A2,LEN(A2)-FIND("_",A2)),A2)

Example

amitraz_123 becomes 123.

Common error

With multiple underscores this formula uses the first one.

How it works

The formula calculates how many characters are after the symbol.

It is useful for codes and imported columns.

Can I extract after a dash?

Yes.

Does it work in Excel 2010?

Yes.