The formulas below will take any text input and return the ASCII value of each character that comprises that string.
Contents:
Formulas
For every ASCII number listed in a single cell (as in the picture above), you can use the following formula:
=TEXTJOIN(" ",,CODE(MID(string, SEQUENCE(LEN(string)), 1)))For a vertically spilled dynamic array use the following formula:
=CODE(MID(string, SEQUENCE(LEN(string)), 1))And for a horizontally spilled dynamic array use the following:
=CODE(MID(string, SEQUENCE(1, LEN(string)), 1))Explanation
These functions can all be broken up into five main parts from the five functions used: LEN, SEQUENCE, MID, CODE, and TEXTJOIN.
We'll use the formula that combines all of the characters into a single cell, and the string "Sample".
The first part of the formula is the LEN function that returns the number of characters in a given cell. In this case, the number 6.
This length number is then fed to the SEQUENCE function, which generates a dynamic array. The size of which matches the number of characters in the cell.
The next step is using the MID function. This function, combined with the array from the SEQUENCE function, will separate a cell into individual characters.
From there, all that is left to do is to use the CODE function to convert the separated characters into ASCII and concatenate them into a single cell using the TEXTJOIN function.
In this formula the delimiter used is a space, " ", but a comma (or any other symbol) could also be used.
