I've been waiting for this guy for two days and he stopped just at the doorway

[SirJB7]

Hi, you!

Yes, you.

No, it isn't spam, it's just 3999, but as I won't be here tonight and for the next three days I wanted to be the first to shake your hand.

Regards!

PS: Maybe some kind Ninja might change this title when this guy decided to add 1 to that number? Thank you a lot.

 

[Luke M]

Ha ha, very nice. I had wondered when he'd break 4k.

 

[SirJB7]

@Luke M

Hi!

I'm sure he did it on purpose. He's waiting for the test match at Argentine tomorrow.

Regards!

 

[Debraj]

@ Me!


Just a salute to the legend..


{=MID("Hi, you!",CHOOSE(COLUMN(A$1),1,7,2),1)}


from... an Excel A B C learner

Deb

 

[Hui]

@SirJB7

I totally missed this post, thankyou

I was traveling interstate last week and so posting was intermittent

 

[Hui]

Deb

Maybe you meant

=MID("Hi, you!",CHOOSE(ROW(OFFSET(A$1,,,3)),1,7,2),1)

Select 3 cells in a column

F2

Paste the above formula Ctrl+Shift+Enter

 

[Debraj]

@ Hui,

Just to point, I have highlight A B C, and you have mention, A1,A2,A3..

Not a problem, unless the salute was not accepted..

Regards,

Deb

 

[Hui]

@Deb

Your formula only returned a H

Unless I've done something wrong?

 

[Debraj]

@ Hui..


In a single cell, write the formula, and then drag toward right.


=MID("Hi, you!",CHOOSE(COLUMN(A$1),1,7,2),1)


Regards,

Deb