add numbers in string

[billypit786]

String=1000;2000;3000;4000

how can i add this nos?

i need this
total = 1000+2000+3000+4000=10000

 

[Douglas J. Steele]

There's a simpler way:

YourString ="1000;2000;3000;4000"
YourTotal = Eval(Replace(YourString, ";", "+"))

 

[Klatuu]

Put that one in the elegant category.

 

[billypit786]

Thanks for ur replies