Refine results

[YasserKhalil]

Hi everybody
I have data in column A
for examples:
ahmed145@yahoo.com:142542
142542:ahmed@hotmail.com

I want the results to be :
ahmed145:142542
142542:ahmed

In other words I want to remove @ and the text until the character :
and if @ after the character : should be removed till the end

 

[jeffreybrown]

Does this work...

=IF(FIND("@",A1) < FIND(":",A1),LEFT(A1,FIND("@",A1)-1)&MID(A1,FIND(":",A1),LEN(A1)),LEFT(A1,FIND("@",A1)-1))

 

[YasserKhalil]

Thank you very much Mr. jeffreybrown