That worked! Thanks Gord.

Quote Originally Posted by Gord Dibben
Combine A1 and C1 with the / in between.

=A1 & " / " & B1 entered in C1

Note the spaces on either side of the /

Drag/copy down Column C or double-click on the fill handle of C1 to copy down.

Copy Column C and in place, Paste Special>Values>OK>Esc

You can delete Column A and B if so desired.


Gord Dibben MS Excel MVP[/color]