I have a column which has values of 6 charaters, followed by "-", followed by a number. I want to replace the original value with the number only.

For example - If the column has a value of ABCXYZ-123. I need to replace it with 123. Need it for all the rows of that column.

I was also able to right an Excel formula for the same - ***=NUMBERVALUE(MID(B2,(FIND("-",B2)+1),LEN(B2)))***

How to do the same in Python?