Replacing characters

[TheBadOne]

I need to remove from the value of [ID] ([just in case [ID]="A1-433434534") all the characters before the dash and the dash itself. The characters up to the dash can always be different (A1, B7, D72 etc). The result should be like this – "433434534".
What formula should I apply? I'm guessing I need to use SUBSTITUTE()

[Suvrutt_Gurjar · Accepted solution]

There can be several approaches, please try 

INDEX(SPLIT(SUBSTITUTE([ID],"-"," , "),","),2)

Another option could be

SUBSTITUTE(EXTRACTMENTIONS(SUBSTITUTE([ID],"-","@")),"@","")

And another option could be

RIGHT([ID],LEN([ID])-FIND("-",[ID]))

[TheBadOne]

Thanks, 1st variant worked.

[Suvrutt_Gurjar]

You are welcome.