1st u need this tools
notepad gametun for like this symbol --> : copy , paste
go to spread sheet, paste ang email sa row cell A & 1
next, symbol ---> ( : ) gkan sa notepad, didto i paste sa c or d or more, row cell, 1
go to spread sheet, paste ang email sa row cell A & 1
next, symbol ---> ( : ) gkan sa notepad, didto i paste sa c or d or more, row cell, 1
i paste balik ang email sa row cell 1 , E or F or more pataas
copy all, paste into this site
http://www.checkerz. altervista.org/spotify/
after done - ang alive muy copyha
go to this site
http://www.unit-conversion. info/texttools/replace-text/# data
find text : & |PREMIUM - copy output,
balik sa google doc spread sheet, paste all
balik sa google doc spread sheet, paste all
highlights duplicated email - delete colum "D-E or asa cya naka plastar, not row
https://www.miniwebtool.com/ remove-spaces/