NEED a bit EXCEL help!

hi, how can i convert a list of names in a column
to a rows with 6 names on each row?

from this :
[TABLE="width: 115"]
[TR]
[TD]vintagebless[/TD]
[/TR]
[TR]
[TD]ceyceyl[/TD]
[/TR]
[TR]
[TD]lisa4U[/TD]
[/TR]
[TR]
[TD]lmack[/TD]
[/TR]
[TR]
[TD]thefaschion[/TD]
[/TR]
[TR]
[TD]lisafleurdelisa[/TD]
[/TR]
[TR]
[TD]morinl1[/TD]
[/TR]
[TR]
[TD]sizzerhappy418[/TD]
[/TR]
[TR]
[TD]lisapatb[/TD]
[/TR]
[TR]
[TD]TINJ[/TD]
[/TR]
[TR]
[TD]lisaou11[/TD]
[/TR]
[TR]
[TD]lisa_hasel[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]+++++++++++++++++++++++++++++++++++++++++++++++++++++
to this:

vintagebless ceyceyl lisa4U lmack thefaschion lisafleurdelisa
morinl1 sizzerhappy418 lisapatb TINJ lisaou11 lisa_hasel


[/TD]
[/TR]
[/TABLE]

You can use CONCATENATE function. Works even on very old Excel versions:

Way in notepad++:

Copy the column to notepad++ . Fireup replace screen by pressing ctrl + h -> select "search mode" as "regular expression" -> in find box enter [\r\n]{1,} and in replace box enter <space> ( type your spacebar once. don't copy this lol). > Click "replace all".

Done