Merging Multiple Cells Into One Cell with exceptions

Hi, I am obviously new to the forum and am wanting to get better with excel. This is a work project where I am trying to merge cells when there is a value the cell and append a comma and a space when the cell is not null. Example: Some cells with have data whereas some will not. In Row 1, I am trying to move name1 name2 and name3 into another cell (this I have tackled), but at the same time keep the cell grammatically correct by separating them with a comma and a space. In row 2, I am trying to move name4 and name 5 into another cell using the same above described formatting. Row 3 would just display "name6" (with no comma or space). And for row 4, I need to be displayed "name7, name8" etc etc etc.....I tried using a concatenate with an if istext, but could not get the cell to put out a value. As well, I have a little bit of programming background in C, but haven't really messed with it in some time. Half of my problem is not knowing excel's syntax. Thanks in advance. By the way, this is not homework or anything like that (I don't know what your rules are here), I am trying to shine at a new job. Again, thanks.

a b c
1 name1 name2 name3

2 name4 name5

3 name6

4 name7 name8


edit: this is not spacing correctly on the thread. Assume "name1" is in cell a1, "name2 is in cell b1, "name3 is in cell c1 etc, "name8" is in cell c4. Cells c2, b3, c3 and b4 are all blank. Haha, this looks a little confusing now....I guess my next question should be "how can I post in a forum with the spacing seen as I see it?"

Welcome to the forum.

Here is en example of how you can concatenate values from different cells into one

=A1&" "&B1&" "&C1

	A	B	C	D
1	name1	name2	name3	name1 name2 name3

Try this...

Data Range

	A	B	C	D	E
1	name1	name2	name3	------	name1, name2, name3
2	name4	name5			name4, name5
3	name6				name6
4	name7		name8		name7, name8

This formula entered in E1 and copied down:

=TRIM(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(SUBSTITUTE(A1
&","&B1&","&C1," ","~"),","," "))," ",", "),"~"," "))

Works OK for me.

Here's a sample file:

Here is more cells
in H1 and copy formula down

=SUBSTITUTE(TRIM(A1&" "&B1&" "&C1&" "&D1&" "&" "&E1&" "&F1)," ",", ")

	A	B	C	D	E	F	G	H
1	name1	name2	name3					name1, name2, name3
2	name4		name6	name7				name4, name6, name7
3	name9	name10		name12	name13	name14		name9, name10, name12, name13, name14

I should note that the formula I suggested is more robust in that it accounts for cells that may contain either spaces or commas.

For example:

Data Range

	A	B	C	D	E
1	John Smith		Joe Camel	------	John Smith, Joe Camel
2		Misty Rain, Tina Fey	Amy Long		Misty Rain, Tina Fey, Amy Long
3

If your data will never have those characters then use AlKey's formula.