MS Excel / VBA help thread

You could write a vba function that concatenates all the cells in a row together, | separated. Here's one:

Public Function Sconcat(rng As Range, Optional delim As String = "|")

    Dim cellIt As Variant
    Dim returnValue As String

    For Each cellIt In rng.Cells
        returnValue = returnValue & delim & cellIt.Value
    Next cellIt

     returnValue = Right(returnValue, Len(returnValue) - Len(delim))

    Sconcat = returnValue

End Function

Call it from the worksheet as =sConcat(B2:D2), where B2:D2 contains the row you want to stuff together, copy it down for each row. Copy the resulting column into a textfile.