Hello all,
I get e-mails from people who have to hand me numbers of man-days or man-hours. Is there a way using VBA to:
- put the string in a cell
- extract only the numbers from the strings I get
- yet include the plus-sign "+"
- replace the American-style dot with a comma
- keep the different numbers a part (not added)
- put the result back in the same cell
Example: if I get this string and put in in cell B1:
3MD+1.5md + 4.2 days
I would like to get this result, regardless of use of capitals or other ("MD" or "days" or "d" or whatever) and regardless of the use of a dot or a comma, again in cell B1:
= 3 + 1,5 + 4,2
of course, the result shown in the cell would be the addition of the numbers (8,7), which is fine, only in the formula bar, one would be able to see where this result comes from.
The use of TEXTJOIN doesn't give me what I want (it would show 31542)
Many thanks for your input.
Pat.
I get e-mails from people who have to hand me numbers of man-days or man-hours. Is there a way using VBA to:
- put the string in a cell
- extract only the numbers from the strings I get
- yet include the plus-sign "+"
- replace the American-style dot with a comma
- keep the different numbers a part (not added)
- put the result back in the same cell
Example: if I get this string and put in in cell B1:
3MD+1.5md + 4.2 days
I would like to get this result, regardless of use of capitals or other ("MD" or "days" or "d" or whatever) and regardless of the use of a dot or a comma, again in cell B1:
= 3 + 1,5 + 4,2
of course, the result shown in the cell would be the addition of the numbers (8,7), which is fine, only in the formula bar, one would be able to see where this result comes from.
The use of TEXTJOIN doesn't give me what I want (it would show 31542)
Many thanks for your input.
Pat.