are you willing to do some manual labour?


in B2
=RIGHT(A1,LEN(A1)-4)

in C2
=RIGHT(A2,LEN(A2)-6)

in D2
=ROW()


select 6 cells
B1:D2
copy to clipboard


select from B1 to end of sheet (3 columns)
paste from clipboard


copy to clipboard
go elsewhere
paste special:Values

sort by last column
then drop those empty rows at end
(and drop the last column)