Multi-informational list items can be separated by the “|” pipe symbol for readability and parsing. Use Excel formulas to parse large amounts of data.


Example of combing three columns with each item separated by the “|” pipe symbol.

Formula:       =B1&" | "&C1&" | "&D1


If you have any questions or need assistance, please contact 2nd Sight at 509-381-2112 or