Im trying to Merge sets of names in Excel 2000. Fairly easy
to get the last name in cell b1 and the first name in cell c1 together

in A1 type = C1 & B1
is there an operator you can use to that when you key in 2 or 3 sets of
names into one cell that after each name it will skip down to the next line?

Something like
= C1 & B1 &"skip to next line" & E1 & D1 &"skip to next line" & G1 & F1

Thanks