If the states are always, 2 chars...

then in another column, say column L2.... =Left(J2,2)

in in M2, =Substitute(J2,L2,"")

both copied down

Then you can copy these 2 columns, go to J1 and Edit|Paste Special >> Values over top...

Then delete the remaining formula column.