Sum up concatenation values

[default_name]

Hello,

Is there any way to sum up the numeric values of concatenations?

Example below.
The data displayed in cells A2:D2 are a result of some concatenations.
In cell E2 I would like to be able to sum up those concatenated values.
In this case, E2 should come up as 137 days.

Stipulations:
I cannot remove those concatenations in columns A:D.
I cannot use macros/VBA for this.

Is these any way this can be done? Thanks

	A	B	C	D	E
1	Step 1	Step 2	Step 3	Step 4	Total Days
2	5 days	28 days	103 days	1 day
3

 

[gaz_chops]

You're welcome

 

[lrobbo314]

Also thank you to lrobbo314 for providing a vba option if it ever needed it.

Thanks for the feedback. Quick correction, the solution was Power Query not VBA.