Excel CONCAT and CHAR Functions
Use Excel's CONCAT to combine values into a single string of text. Use CHAR to include non printable characters such as TAB and LINE FEED. Check out www.asciitable.com for a list of codes to use with the CHAR function.