Help FAST ! Duplicated text in cells !

Hello, i have 2 columns.The first one is like this in all 16 000 cells

"РУСЕ ВЪЗРАЖДАНЕ ,УЛ.-,БЛ.А ВЕНТУРА,ВХ.А,ЕТ.7;РУСЕ, РУСЕ УЛ. НИКОЛА ПЕТКОВ 1 ВХ. 4 ЕТ. 5;РУСЕ, РУСЕ УЛ. НИКОЛА ПЕТКОВ 1 ВХ. 4 ЕТ. 5;РУСЕ, РУСЕ УЛ. НИКОЛА ПЕТКОВ 1 ВХ. 4 ЕТ. 5;РУСЕ, РУСЕ УЛ. НИКОЛА ПЕТКОВ 1 ВХ. 4 ЕТ. 5;РУСЕ ул. Воден "

The other one is like that

0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865;0885144844;820865

I tried this code or whatever it is

Please Login or Register  to view this content.

It gives me error
Run-time error '1004':
No data was selected to parse.

at the

Please Login or Register  to view this content.

I will be very grateful if someone helped me.