How to get individual numeric value from cell text?

Question

excel

Someone asked me a question. Is it possible to get a number from a cell with some word?
Example:
Watermelon - 3243423
Dog - 323123 ololo
- 81763
The first thing that came to my mind was to convert the characters into their codes and add/multiply them. But the problem. Excel can do this only with the first character in the cells, and not with all the text from the standard functions.
How to get an individual value for different words using regular means, provided that the words for are not previously set and the repeated words must have the same codes?

Answer 1

Funny task.
So far, I've come up with this:
\u003d LONG (B5) + CODE (B5) + CODE (RIGHT (B5; 1))
But yes, the value is not too unique, only the first-last character and the length of the string are checked

Answer 2

Isn't it more optimal (judging by your example) to translate the book into CSV and import the data with the "-" separator?

Answer 3

Maybe MD5?