Hi,

I would greatly appreciate the assistance of you Excel mavens. Here's what I
would like to accomplish:

1) My rows that have a field that looks like this (no quotes):
€œTaskName, 12+75+42+5+36€�
a. Note that the numbers above (ie. 12+75+42+5+36 in this example)
vary from row to row. For example, the cell in the next row might look like
this (no quotes):
€œTaskSize, 10+22+84€�

2) I would like to create a macro that would look at that cell and then do
the addition on the numbers on the right (ie. 12+75+42+5+36 or 10+22+84),
while ignoring the text on the left (ie. TaskName, ) (ie. Taskname comma
space)

3) I would then like the macro to put the result of the math in a filed that
is 5 columns to the right.

This may be pretty easy, but I am not quite certain how to accomplish the
parsing of the variable amount of numbers and plus signs within the field. My
guess is that somehow Excel can read the cell form right to left, and then
know to stop when it sees the €œ, €œ (ie. comma and a space).

I look forward to your thoughts on this one.

Regards,
Brcobrem