Discover the magic of the CHAR function in Excel - Concatenation, Carriage Returns and more ....
Channel: prelearn
Date: 11/07/2021

This how to get data from tabular structure to a form you wish

To Concatenate: Use & (ampersand)

To Add Special Characters: User CHAR()
CHAR() requires a number, the ASCII code of the character you need

Link to lookup ASCII codes:
http://www.asciitable.com/

#excel #hacks #learn