Good Morning,

I have some data below

A1 -> TEST - 123 - 965A

A2 -> TEST - 111 - 656 - 965ASD

I need to break it so it looks like this

B1 -> 965A
B2 -> 965ASD

I need to fetch the 20 characters after the last "-"

Can be VBA or formula.