Hi, I came across this formula on an excel forum but there was no story behind it.
=CHAR(CODE(LEFT($C6,1))+3)&""&CHAR(CODE(MID($C6,2,1))+3)&""&CHAR(CODE(MID($C6,3,1))+3)&""&CHAR(CODE(MID($C6,4,1))+3)
I was hoping someone could shed light on this! Where and why would we use this formula? A scenario will be very helpful!
Thanks a lot!
Not sure where I'd use something like that, but...
that formula increments the 1st 4 letters of the text in cell C6 by 3 positions to the right.
Example:
C6: AEIOU
The formula returns: DHLR
Please Login or Register to view this content.
It looks like a simple coding system which takes the first 4 letters of whatever is in C6 and shifts each letter 3 places up the alphabet. So, if you had ABCD in C6 the result from the formula would be DEFG.
There is quite a bit of redundancy in the formula - it could be simplified to this:
=CHAR(CODE($C6)+3)&CHAR(CODE(MID($C6,2,1))+3)&CHAR(CODE(MID($C6,3,1))+3)&CHAR(CODE(MID($C6,4,1))+3)
Hope this helps.
Pete
The formula is taking a 4 character string in the cell and getting the numeric code value of each character then adding 3 to that code value then converting that code value into a new character.
For example, enter this word in C6: Lost
The formula returns Orvw.
Here's how it breaks down:
CODE("L") = 76 + 3 = 79 = CHAR(79) = O
CODE("o") = 111 + 3 = 114 = CHAR(114) = r
CODE("s") = 115 + 3 = 118 = CHAR(118) = v
CODE("t") = 116 + 3 = 119 = CHAR(119) = w
="O"&"r"&"v"&"w"
=Orvw
What purpose it serves is hard to say.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you all! I might use it for any confidential documents..
You're welcome. Thanks for the feedback!
I'm pretty sure the NSA can break that encryption method!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks