Hello all,

I've done alot of searches already and still couldn't find a solution to my unique problem.

I need to convert a particular cell of "text" into a value based on the sum of the individual characters on alpha order. Some cells would contain spaces, numbers and common symbols too.

For example,

"ABC" will convert to "6" (1+2+3)

or

"AB BA 3" will convert to "9" (1+2+2+1+3)

or

"AB/C" will convert to "6" (1+2+0+3) (anything other than text/number is 0)

Is this even possible?

My problem is that I need to identify each particular cell with an unique number, and these cells have unique texts including numbers/symbols.

Please help.

Thanks!