In A column are like this '[email protected] : pass', i need to remove this part ': pass'

In A column, i have hundreds email account cells like this :

Please Login or Register  to view this content.

i need to remove the rigth part

Please Login or Register  to view this content.

so the cells just leave like this

Please Login or Register  to view this content.

please help guys, how to do that, GBU for that answering

=trim(left(a1,find(":",a1)-1))

assuming data is in column A

Give this a shot...

=LEFT(A1,FIND(":",A1)-2) >> copy down

=trim(left(a1,find(":",a1)-1)) oh look 3 answers nearly all the same!
or use find replace
find space:*
replace with nothing