Your image file doesn't work so i'm only guessing here.
If all you need to do is extract the first 6 characters and then the last 6 would something like the following work? If the length is always the same then this will work but if characters are added or removed in difference cells this won't be a fix all.
=RIGHT(A4,LEN(A4)-7) - This removes characters left to right
=LEFT(A4,LEN(A4)-7) - This removes characters right to left
A4 being the cell that you are removing characters from
-7 is how many characters you are removing from the cell.
If you are left with spaces you can put the following
=TRIM(RIGHT(A3,LEN(A3)-7)) - This will remove spaces from the beginning.
Alternatively if there are characters left over that are common throughout you can try
=RIGHT(SUBSTITUTE(A3,"ABC",""),LEN(A3)-10)