i want to split a cell with a formula and not use text to columns. i will have a cell a1 for example with 1d 4h 36m 34s in and want to have 4 formulas 1 in
a5
a6
a7
a8

.. so the result will be

1
4
36
34

i know you can split with left, mid and right but dont know how to do it with the desired results

thanks,

wayne