See if this helps

Say data starts in A1 enter this in B2 and drag down

=A1&"-"&A2
VBA Noob