How do I group different rows in a field?

I need to group together names in multiple rows to one row in Excel.?

• I have a file that has 5000 plus names all on seperate rows in the same column. (These names are on seperate lines) Unfortunately I need them to be on the same line and excel will not allow me to merge them. Is there a way to put them on the same line (row) using a formula? Also, the names need to have bullet points between them. Example: This is what I have: Line 13 Col. A : Scwalbe, Peter Line 14 Col. A: Slivon, George This is what I need: Line 13 Col. B: P. Scwalbe (bullet) G. Slivon <--sorry I couldn't insert a bullet to make it look correct Some have 2 lines (rows) with names some have 3 lines (rows) with names and others have like 6 or 7. Any help please!

• Answer:

  You can try this macro.. it creates a UDF (user defined function) Function ConCatRange(CellBlock As Range) As String Dim cell As Range Dim sbuf As String For Each cell In CellBlock If Len(cell.Text) > 0 Then sbuf = sbuf & cell.Text & "