I am using live data sheet in which I want to split each cell number into individual number and add them.

```
Example: 
cell A1 contains number 265.96
Into 26596 and add these number
ie 2+6+5+9+6

```