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 us at 509-473-0252 or info@innovate.ag