Shorten long formula

[YasserKhalil]

I have this formula that search for specific texts within range a1 and if there is any text of them will add "@members"..if not a1 will be as it is

here's the formula

=IF(OR(ISNUMBER(SEARCH("@gmail.com";A1));ISNUMBER(SEARCH("@yahoo";A1));ISNUMBER(SEARCH("@hotmail.co";A1));ISNUMBER(SEARCH("@myrlfh.com";A1));ISNUMBER(SEARCH("@live.com";A1));ISNUMBER(SEARCH("@ihug.co.nz";A1));ISNUMBER(SEARCH("@aol.com";A1));ISNUMBER(SEARCH("@talktalk.net";A1));ISNUMBER(SEARCH("@odonnellandmellon.com";A1));ISNUMBER(SEARCH("@blueyonder.co";A1));ISNUMBER(SEARCH("@gv.net";A1));ISNUMBER(SEARCH("@optonline.net";A1));ISNUMBER(SEARCH("@abv.bg";A1));ISNUMBER(SEARCH("@comcast.net";A1));ISNUMBER(SEARCH("@googlemail.com";A1));ISNUMBER(SEARCH("@btinternet.com";A1));ISNUMBER(SEARCH("@amjt.karoo.co";A1));ISNUMBER(SEARCH("@sky.com";A1));ISNUMBER(SEARCH("@deviangroup.com";A1));ISNUMBER(SEARCH("@publicclass.com";A1));ISNUMBER(SEARCH("@T-Online.de";A1));ISNUMBER(SEARCH("@cox.net";A1));ISNUMBER(SEARCH("@vtxnet.ch";A1));ISNUMBER(SEARCH("@live.fr";A1));ISNUMBER(SEARCH("@fcu.edu.tw";A1));ISNUMBER(SEARCH("@sbcglobal.net";A1));ISNUMBER(SEARCH("@terra.es";A1));ISNUMBER(SEARCH("@excite.com";A1));ISNUMBER(SEARCH("@CoB";A1));ISNUMBER(SEARCH("@msn.com";A1));ISNUMBER(SEARCH("@Rubesick";A1));ISNUMBER(SEARCH("@yahoo.no";A1));ISNUMBER(SEARCH("@email.com";A1));ISNUMBER(SEARCH("@netzero.com";A1));ISNUMBER(SEARCH("@aim.com";A1));ISNUMBER(SEARCH("@verizon.net";A1));ISNUMBER(SEARCH("@welchol";A1));ISNUMBER(SEARCH("@feuerwehr-kettig.de";A1));ISNUMBER(SEARCH("@pacbell.net";A1));ISNUMBER(SEARCH("@odu.edu";A1));ISNUMBER(SEARCH("@gmx.de";A1));ISNUMBER(SEARCH("@bespoke-ni.com";A1));ISNUMBER(SEARCH("@du.ch";A1));ISNUMBER(SEARCH("@hotm";A1));ISNUMBER(SEARCH("@juno.com";A1));ISNUMBER(SEARCH("@rrel";A1));ISNUMBER(SEARCH("@webtv.net";A1));ISNUMBER(SEARCH("@cybernet.ch";A1));ISNUMBER(SEARCH("@goodthinxx.com";A1));ISNUMBER(SEARCH("@tiscalinet.ch";A1));ISNUMBER(SEARCH("@charter.net";A1));ISNUMBER(SEARCH("@web.de";A1));ISNUMBER(SEARCH("@ukonline.co";A1));ISNUMBER(SEARCH("@pandora.";A1));ISNUMBER(SEARCH("@hawaii";A1));ISNUMBER(SEARCH("@earthlink";A1));ISNUMBER(SEARCH("@lumenart.de";A1));ISNUMBER(SEARCH("@gmx.net";A1));ISNUMBER(SEARCH("@tc.umn";A1));ISNUMBER(SEARCH("@telia.com";A1));ISNUMBER(SEARCH("@tampabay";A1));ISNUMBER(SEARCH("@master.karoo";A1));ISNUMBER(SEARCH("@ormus.ws";A1));ISNUMBER(SEARCH("@http.com";A1));ISNUMBER(SEARCH("@ehE2Y";A1));ISNUMBER(SEARCH("@rbn";A1));ISNUMBER(SEARCH("@ukr.net";A1));ISNUMBER(SEARCH("@id ";A1));ISNUMBER(SEARCH("@aon.at";A1));ISNUMBER(SEARCH("@cWmz5";A1));ISNUMBER(SEARCH("@cachondo.";A1));ISNUMBER(SEARCH("@sasktel.";A1));ISNUMBER(SEARCH("@tic ";A1));ISNUMBER(SEARCH("@hoteldecebal";A1));ISNUMBER(SEARCH("@nkliker";A1));ISNUMBER(SEARCH("@ley15136";A1));ISNUMBER(SEARCH("@deone1";A1));ISNUMBER(SEARCH("@l ";A1));ISNUMBER(SEARCH("@yahoo.co";A1));ISNUMBER(SEARCH("@yahoo.co";A1));ISNUMBER(SEARCH("@yahoo.co";A1));ISNUMBER(SEARCH("@yahoo.co";A1));ISNUMBER(SEARCH("@yahoo.co";A1)));A1&"@members";A1)

 

[Saagar]

Are you looking for specific domains to appear in the email address to append "@members" or do you want to append "@members" to any email address that is present?

 

[YasserKhalil]

How can I use an array to shorten this formula?

 

[YasserKhalil]

I want to append "@members" to any email address that is present

 

[Dannyh1]

Hi maybe try:

=IF(ISERROR(LEFT(A1,FIND("@",A1)-1)&"@members"),A1,(LEFT(A1,FIND("@",A1)-1)&"@members"))

 

[YasserKhalil]

Hi maybe try:

=IF(ISERROR(LEFT(A1,FIND("@",A1)-1)&"@members"),A1,(LEFT(A1,FIND("@",A1)-1)&"@members"))

thanks for help
But I don't want to remove the domain
for example
sdsdf.dsf@yahoo.com@www.dcfdf.com
would be
sdsdf.dsf@yahoo.com@www.dcfdf.com@members

 

[barry houdini]

If the presence of @ denotes an email address then try this formula

=A1&IF(COUNTIF(A1,"*@*"),"@members","")

 

[Dannyh1]

Hi what about:

=IF(ISERROR(FIND("@",A1)),A1,A1&"@members")

 

[Saagar]

Try this:
=IF(ISERROR(SEARCH("@",A1,1)),A1,A1&"@members")

This function searches for "@" to appear in the string. If it appears, it appends "@members", otherwise it doesn't.

 

[YasserKhalil]

Thanks for all of you
but I have various data
for example
sdf.dsfsdf@www.fdfdf.com
in this example i don't want to add "@members"
I just want to add according to my conditions...