Change letters into specific Numbers

Hello,

I searched and searched and could find 0 information on this, so here I am asking for your genius help!

I am trying to figure out the Formula to change letters into specific numbers.
I want To type a word in column A and the result in column B to be the string of numbers that correspond to that words letters.
Based on 1=A,J,S; 2=B,K,T; 3=C,L,U; 4=D,M,V; 5=E,N,W; 6=F,O,X; 7=G,P,Y; 8=H,Q,Z, 9=I,R

examples: So, If I enter BIRD into column A the result in column B would be 2994
or if I entered GEORGE BEAUFORT in column A the result in column B would be 756975 25136692 (The space is not required for what I need so the result could (preferably) be 75697525136692)

Thank you so much, in advance!
SS

Hi JohnTopley,

Thank you for your reply. I do not really understand what that means.
I am at a "beginner" level when it coms to this stuff.
I was hoping for just a formula. But if that is not possible, more specific instruction would be SUPER helpful!
Thank you!
SS

Try this formula Cell B1 , Drag down

Formula:

Please Login or Register  to view this content.

Originally Posted by wk9128

Try this formula Cell B1 , Drag down

Formula:

Please Login or Register  to view this content.

WK9128, This did Not work.
But thank you soooo Much for trying!

Originally Posted by ELeGault

This is a bit of VB that you would add by Hitting ALT+F11 on your keyboard.

Right click on the sheet in the Project Explorer in the upper left of the new window that came up.
Hover over INSERT and SELECT MODULE

Paste the code into that MODULE. Once done you can close the Visual Basic Editor window.

The formula is now active ONLY in the book you add it to. =LetterToNum(CellReference) and it will convert the string to the values as you have outlined.

To do this in a formula without a custom function like JohnTopley provided would be a rather gross formula in length...so if this is a viable solution for what you need... I would definitely go this route!

Thank you sooooo much! Perfect instructions! I got the code working AND now know how to do it!
SS

Originally Posted by JohnTopley

Please Login or Register  to view this content.

=lettertinum(A1)

THANK YOU!!! SOOOO MUCH!!! This worked great and is exactly what I needed!
SS

@shawnashannon You're Welcome. Glad to help . Thank You for the feedback

There is no problem with the formula, please see the place painted in yellow