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

Somebody may have a cooler way of doing this, but try this...format the
cell so it does text wrapping:

Then do something like this:

=B1&" "&B2


And you just need enough spaces in between the quotes so it falls on
the next line. I dont think you can put in a return to the next line,
so this is a way to cheat.

= C1 & B1 & char(10) & E1 & D1 & char(10) & G1 & F1

format the cell for Word Wrap or the Char 10 will look like a square.

--
Regards,
Tom Ogilvy

"TSW" wrote in message
...
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