A macro for crypto!!!

Hello everyone. I just want to say that this macro will make many things easier for me. Let me explain.

I'm going to write a novel or say some kind of thing like that and I need a private language which make it only readable for myself. Lets say :

an "a" in my own language will be "d" actually. And a "b" means "r" and like these examples, all letters in my own language will nominate another letter. Is there a way to do this ? I will work in Microsoft Word and I want to paste my writings to a cell in excel and when I start the macro it will change the writings into another cell.

Lets say when I paste this sentence into cell a1 :

"Today is the best day in order to..."

and started the macro I want to get this sentence in cell a2

"Ahntı pu aov kvua ntı hznvz ah..."

Is it possible ?

Thanks in advance.

See the attached for an example. It is a simple substitution cypher mapping characters ASCII 32 thru ASCII 255. Tab "substitution" column D is the input character and column E is the output character.

Tab "sample" cell A1 is an input and B1 is an output.

Then you need to supply me a complete list of the translation table............similar to what I supplied in cols D & E.

If we assume that blanks and special characters are not translated, you only need to supply a table with 26 entries.

Here is the UDF that will perform the translation:

Please Login or Register  to view this content.

I am having a problem in the translation of upper case characters. In you latest post, you have upper case I entered twice:

A-B-C-Ç-D-E-F-G-Ğ-H-I-I-J-K-L-M-N-O-Ö-P-R-S-Ş-T-U-Ü-V-Y-Z

Your new translation table is now in columns A & B of the xlt tab.
The Data tab shows some examples of the translation.

Thank you for the feedback!

Do you mean limiting the number of characters the function will return??

There is no limit in Code2.xlsm.

What limit do you desire?

Try this:

Please Login or Register  to view this content.