how do you type "power" in one go

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Congratulations on your binary achievement, Erik. :-)
 
Erik - you are an international man of mystery - I couldn't possibly reveal your secret!
(Oaktree apparently has no such compunction ;) )
 
Erik

Although my background is in mathematics, I don't think I would have worked this out if it weren't for the hints provided.

As it turns out, yesteday I must have got to be 2^-(2^0) as good as you. ;)
 
Last edited:
Y^ep, Pe^ter^,
Problem^ wi^th t^hose milest.nes is that the next one is always further ...... How will I ever get there? ... Don't count on me, anyway not in the Lounge ........ But let's :beerchug: ....
 
Y^ep, Pe^ter^,
Problem^ wi^th t^hose milest.nes is that the next one is always further. How will I ever get there?

Felicitations, Erik!

Took me a while to figure it out, but without meaning to sound rude, aren't you already past it?:laugh:
 
no enigma in this message, just straight text :-)

I am waiting for Greg Truby to reveal the mistery: he should know
(wondering why he didn't show up here: perhaps because there was an invitation to divert the thread)
 
seems like Greg is not in the neighbourhood
so here it is

2^14 = 16384
I started this thread just before my post 16384

Y^ep, Pe^ter^, Problem^ wi^th t^hose
(1 character ^ 6 characters ^ etcetera)

. ...... ... ........ ....

(typo on purpose, was the "s" to get 6 characers in that word)
O thanks you pakistan riaz

as always, just playing :lol:
 

Forum statistics

Threads
1,222,681
Messages
6,167,581
Members
452,120
Latest member
Luis_Macros

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top