Displaying Characters Corresponding to Numeric Codes

Expected Effect

Sometimes you need to display the text character corresponding to the value field. For example, the two columns of values are converted to, and displayed as, their corresponding text characters. After that, the two columns of data are concatenated together.

Implementation Method

Click the Formula Column button to add CHAR Function to the data.

Meanwhile, use CONCATENATE Function to achieve the concatenation functionality.

You can download the sample data: Char.xlsx.

Creating an Analysis Subject

Create an analysis subject and add the sample data Char (all fields selected by default), as shown in the following figure.

Adding a Column

Add Formula Column, name the field as numbers to characters, enter the function CONCATENATE(CHAR(Number1), CHAR(Number2)), and click OK, as shown in the following figure.

Note:

Functions and fields in the formula need to be selected from the left selection area and cannot be entered manually.

Effect Display

You can see the content of the converted and concatenated field type. For details, see section ''Expected Effect.''