6174 Kaprekar’s constant
This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads walk you 6174
This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads walk you 6174
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using …
Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)
Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.
I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but …
Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only that day name This is …
I needed few months back to make a fixed-length ID iut if none-fixed-length numbers. SO I used the function REPT with RIGHT to force all numbers to be converted into …