CHAR and CODE Functions Can Do Magic- Excel Tips and Tricks
Char ► Converts any number from 1 to 255 to their corresponding character
Code ► Returns a numeric code for a Character
These 2 underestimated functions are used as support functions when building more advanced functions with multiple nested levels, but they have other uses that we will explore in this tutorial.
Watch how I combine them with: ROW Function, TEXTJOIN Function, MID Function, LEN Function, SEQUENCE Function, CONCAT Function, RANDBETWEEN Functions.