Where do we send answers of the challenge of the month?

[Haris80cr]

HI ALL,
a very simple question...
I have completed the challenge of the month, where do I send it?

thanks.

 

[shajueasow]

CONGRATS.........
As said in the "challenge post":

Download and unzip marchallenge.zip. Return your completed worksheet to bill at mrexcel.com.

 

[Haris80cr]

Thanks i noticed that, but what is bill? is is a person? am email? English is not my native language. more help please...

 

[dave3009]

Hi Haris80cr

Send a Private message through to Bill. Bill Jelen runs this site. To send the message go to Private messages then send and address it to Bill.

Hope this helps


Dave

 

[Greg Truby]

Bill doesn't post his actual e-mail address to help keep the bots from grabbing it and selling it to the spammers. So, to put it in terms we can all understand, it's: <ul>[*]=REPLACE("Bill at MrExcel.com",5,4,"@")[/list]

 

[Richard Schollar]

Would that be the same guy as at:

=Substitute("Bill at MrExcel.com"," at ","@")

?

 

[Greg Truby]

Nope, that's a completely different chap.

 

[Haris80cr]

Thanks

=CLEAN(IF("MONKEY"="monkey",LEFT(TEXT("Thanks","#.###.###.###,###")&REPLACE(" BUT YOU COMPLICATE THINGS",1,50,".")&SUBSTITUTE("FOR NO APARENT REASON","FOR NO APARENT REASON","I apperciate that.",1),50),""))

 

[shajueasow]

Re: Thanks

=CLEAN(IF("MONKEY"="monkey",LEFT(TEXT("Thanks","#.###.###.###,###")&REPLACE(" BUT YOU COMPLICATE THINGS",1,50,".")&SUBSTITUTE("FOR NO APARENT REASON","FOR NO APARENT REASON","I apperciate that.",1),50),""))

I think that is a very good way to say what you have to say in an excel site.....

 

[Richard Schollar]

Re: Thanks

=CLEAN(IF("MONKEY"="monkey",LEFT(TEXT("Thanks","#.###.###.###,###")&REPLACE(" BUT YOU COMPLICATE THINGS",1,50,".")&SUBSTITUTE("FOR NO APARENT REASON","FOR NO APARENT REASON","I apperciate that.",1),50),""))

Ahh, the Trubinator strikes again! Way to go Greg