Please for the love of all that is good, DO NOT use char[] to store strings, if that's what you want to do go learn C. Store strings in wells strings. std::string str="hello"; I don't actually know what you mean by convert to numbers, that's very ambiguous. If you mean parse a string into a number than the easiest is: std::string str="1234"; int i=std::stoi(str); // i == 1234 and back again std::string str=std::to_string(i); If what you meant is you want to output the charactors integer value then something like this will work std::string str="hello world"; for(char c : str) { std::cout << static_cast(c); } More on reddit.com

Setup a list on the same or another sheet defining your letters and their associated number assignments. It'll look something like this partial-list:

Then, use this array formula (see note below before submitting) will give you the numeric equivalent of the word you enter into a cell.

=TEXTJOIN("",1,LOOKUP(MID($D$2,ROW(INDIRECT("1:"&LEN($D$2))),1),$A$2:$B$27))

NOTE: That is an array formula. It must be submitted with CSE (Ctrl Shift Enter), not just enter.

In my test, I put the list of letters and their equivalent number assignments in columns A (A2 to A27) and B (B2 to B27) respectively.

I skipped column C.

Then I typed the word "mouth" in D2 and put that formula in E2 (next to the word). The result was 47328. I changed the word to "monday" and it gave a result of 476417.

More on reddit.com

Oh nice! I think I'll use this in a project I'm thinking about. Thanks!

More on reddit.com

The number program (in the bsdgames package on most systems) does this already.

Remember the story of the 10,000 lines.

More on reddit.com