Remove the last occurrence of specific text

[YasserKhalil]

Hello everybody
I have data in column A and I want to remove specific text starting the character @ (the last occurrence of the character)
for example:
1-ayamn55@yahoo.com@www.hhhh.com
2-ayman65@yahoo.com
3-ayman99@gmail.com

In the above examples I want to remove just @www.hhh.com
and keep the second and third instance as it is.

 

[VoG]

Try

=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))=1,A1,LEFT(A1,FIND("@",SUBSTITUTE(A1,"@","~",1))-1))

 

[YasserKhalil]

thanks a lot for your help
I have various data for example
ayman554.19980@http://www.ggggg.com

I want to remove the specific text starting with @
I'm sorry but the various data will make me ask a request after another

 

[VoG]

Try

=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))=2,LEFT(A1,FIND("@",SUBSTITUTE(A1,"@","~",1))-1),IF(ISNUMBER(FIND("www",A1)),LEFT(A1,FIND("@",A1)-1),A1))

 

[YasserKhalil]

very very good
I don't know how to thank you Mr. VoG
It works well with the data that has the text(www) but there are various data and there are some data that hasn't the text (www) what can I do to get rid of these data !!
for example
kk.ayma65@yahoo.com@klf.frrrrrf.ggdf

 

[YasserKhalil]

To make it easy the text after @ may contain one of the following:
www
member
.com

 

[Yahya]

Yaser
كل عام و انت بخير يا صديقي

try this link
http://spreadsheetpage.com/index.php/tip/extracting_an_email_address_from_text

 

[YasserKhalil]

Mr. Yahya
كل عام وأنت بخير أبا الحسين
بارك الله فيك
Thanks for help ...But I don't want to extract the emails..

 

[VoG]

Try

=IF(LEN(A1)-LEN(SUBSTITUTE(A1,"@",""))=2,LEFT(A1,FIND("@",SUBSTITUTE(A1,"@","~",1))-1),IF(OR(ISNUMBER(FIND("www",A1)),ISNUMBER(FIND("member",A1)),ISNUMBER(FIND(".com",A1))),LEFT(A1,FIND("@",A1)-1),A1))

 

[YasserKhalil]

Excellent Mr. VoG
Thank you very much

Another request may be away from the first ine
I have a text that has many spaces I want to extract the text after the first space only
for example
No way of escaping the fate
I want to extract the text "way of escaping the fate"