Yes, something like below
Code:const sDelim as string = " " 'what do you want can be nothing dim i as long i = 2 'presume u skip the header while activesheet.cells(i,3) <> "" activesheet.cells(i,8).value2 = activesheet.cells(i,3).value2 & sDelim & activesheet.cells(i,4).value2 i = i + 1 wend
Bookmarks