Hi there,

Say the data starts in cell A1, enter the following formula =REPT("-",SUM(LEN(A1)-LEN(SUBSTITUTE(A1,"-","")))/LEN("-"))&B1 into cell C1, copy it down as many rows as required, convert the formulas (or Column C) to values and delete Column B.

Kind regards,

Robert

HTH