Sum all digits occuring in text string

[syar]

suppose aap ke cell A1 main 37 likha ho aur aap chahte ho k is ka toal ya sum kistarh maloom karain tu ye forumla Istimal kar sakte hain.

in B1:

=SUM((LEN(A1)-LEN(SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},"")))*{1,2,3 ,4,5,6,7,8,9})
Is ki jagha text string main se bhee aap digit sum ya total kar sakte hain for example

A1= I'm 32 year old and my daughter is 3 year old
OR
Karachi is 135 km and hyderabad is 150 km etc.

regards

[Kutkutariyaan]

Walikum Salam..

Good tip

Thanks

[Shehzad Iqbal]

thanx for sharing

[Aalik]

nice

[mani]

ager hum nai row or colum ko sum ker ho to keise ho gai baji

[syar]

Will you give an example (sample data). Kia aap ye chahte ho k agar mukhtalif cell m text k saath no bhe lekhe ho aur aapun tamam cell ko sum karlo tu yes it is possible . Please provide sample data.

[Jaffary]

[I A Qureshi]

Thanks

[Ali-khan]

MashAllah nice work

[Abu ashar]

Nice sharing, Thanks for it

[Ganxtr]

NYC....
Your thread is very useful, thanks for sharing with us.

[*Tamraiz*]

nice Sharing,.......keep it up