This may sound weird to some but those that know numerology will easily understand it.

I wanted to know if there is the possibility to create a formula that will sum the numbers in a single cell. i.e If i have a cell with 27 it should return 9 summing 2+7 or if i had a 51 it would return a 6

Also if possible should i have a 2 it should return a 2 and should i have a 123 it should return a 6

Did my english pass the message?