value of text in a cell in numbers

[ShyamSharma]

Hi,

I am working on a project wherein we have assigned value to all 26 characters of alphabets e.g a=1, b=1.

Requirement:- As i write some word (not letter) in the cell , it should give the value of word in any other cell.
Since i am not a VBA user, request you to suggest some function based solution.

Hope to hear soon from you on the same.

With Warm Regards

Shyam Sharma

 

[ShyamSharma]

Thank You Formr, Eric and Scott for your replies!!

With Warm Regards

Shyam Sharma