Hi,

Am Sun, 19 Jun 2016 06:03:38 -0700 (PDT) schrieb ANG:

Can you simplify it by ignoring cell A1 and assuming the data is in D1,d2,d3 - get the same result

Column(A1) is a counter for the MID function and must remain in the
formula.


Regards
Claus B.
--
Windows10
Office 2016