I am using a bunch of formulas in combined form to make a Google Sheets formula that ciphers your text. With my formula, you can create ciphered messages. See how to make your own ciphers with Google Sheets.

I am using the following functions for this but in a combination. That means finally there will be only a single piece of formula that can cipher your messages.

I am just telling you the role of these functions in the cipher code that I am going to provide you. You won’t see any individual results of these functions.

1. REGEXREPLACE

2. SPLIT

These two functions help to split the entered text in A2 (see the screenshot below). It splits each character in the text to separate cells.

3. TRANSPOSE

Transpose the split text to a column Array to use in Vlookup as the search keys.

4. VLOOKUP

Vlookup uses a two column array. That you can see within the formula below. One column contains the English Alphabets (A-Z). The second column contains some characters that I’ve populated using the CHAR function.

Vlookup searches down the first column that contains the English Alphabets (A-Z) and returns the ciphers from column 2.

5. IFERROR

6. ARRAYFORMULA

7. CONCATENATE

This function joins the individual cipher characters into a text format.

How to Make Ciphers With Google Sheets

I have already detailed the procedure. Now here is the formula.

=CONCATENATE(ArrayFormula(IFERROR((vlookup(transpose(split(regexreplace(A2&" ", "(.)", "$1 ")," ")),({{"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z";"_"},{"϶";"К";"Ў";"ϸ";"Д";"Ϭ";"Ϩ";"Ж";"Ͼ";"Є";"Ϫ";"Ϯ";"А";"ϲ";"І";"Ѐ";"ϴ";"В";"И";"ϼ";"Њ";"ϰ";"Ј";"Ђ";"Ќ";"Ϻ";"_"}}),2,0)))))

I am using this formula in Cell B2. Type your message in cell A2. This formula would create the ciphered message in Cell B2. This way you can make your own ciphers with Google Sheets.

Features of My Cipher Formula

You can only use the English Alphabets to create your original text. It supports lowercase as well as uppercase letters.

If you want to write sentences, don’t use full stop or space. Instead of space, you can use underscore _.

Can I Personalise The Cypher Codes in this Formula?

Yes, you can. If you use the above codes means, I can read your ciphered messages. Just kidding 🙂

So do personalize it.

The underlined characters represent the English Alphabets A to Z. There is a total of 26 characters. You can replace that characters with any other characters and that in any order.

I suggest you use alphanumeric characters (only numbers 1 to 9 (single digit) and rest of the characters with English alphabets in any order)

You have learned how to make your own ciphers with Google Sheets. Then what about deciphering code.

Create Deciphers With Google Sheets Functions

You have now the ciphered text in cell B2. Copy that ciphered message and right click on Cell A3 and apply the paste value.

In Cell B3 apply this decipher formula.

=CONCATENATE(ArrayFormula(IFERROR((vlookup(transpose(split(regexreplace(A3&" ", "(.)", "$1 ")," ")),({{"϶";"К";"Ў";"ϸ";"Д";"Ϭ";"Ϩ";"Ж";"Ͼ";"Є";"Ϫ";"Ϯ";"А";"ϲ";"І";"Ѐ";"ϴ";"В";"И";"ϼ";"Њ";"ϰ";"Ј";"Ђ";"Ќ";"Ϻ";"_"},{"A";"B";"C";"D";"E";"F";"G";"H";"I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U";"V";"W";"X";"Y";"Z";"_"}}),2,0)))))

This formula has only one change with the cipher formula that I’ve provided in the beginning.

I’ve just changed the position of the columns in the Vlookup. The cipher code characters come first and the English Alphabets moved to last. That’s all.