Romulo Avila
01-12-2018, 04:45 AM
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.
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.