Excel Convert word into numbers and back


Joined
Apr 9, 2018
Messages
3
Reaction score
1
How do we get Excel to recognize each letter in a word and turn them into number? I have read suggestions on how to turn the first or last letter, or just a single letter, into a number but could not find if excel can separate the letters in a word and then convert into numbers. For example Turn "bad" into 214 when a=1, b=2, c=3 and d=4 etc.
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum :) Interesting question, I'll have to have a think on it. What do you want to happen for letters that have a double digit? ie Z = 26? Do they need to be separately distinguished somehow?
 
Joined
Apr 9, 2018
Messages
3
Reaction score
1
No no, it is sufficient to distinguish each letter even if it is three four digits, I can store them separately. I am looking for an attempt at simple cryptology example, convert a word into numbers and hide the original numbers after converting them into more complex numbers, then decode them back to the original word :)
 
Ad

Advertisements

Joined
Apr 9, 2018
Messages
3
Reaction score
1
Thank you for your help Becky, I might choose to do it in MatLab as it probably is easier for me than learning VBA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top