CHAR in Excel (Formula, Examples) | How to Use CHAR Function ...
www.wallstreetmojo.com › char-function-in-excel=SUBSTITUTE(SUBSTITUTE(A2,CHAR(CODE(“?”)),””),CHAR(CODE(““)),”-“) First, we calculated the ASCII code for the ‘?‘, 63, and for the ‘line break,’ the ASCII code is 10. Then, we calculated both values using the CODE function and replaced them with the required output. Applying the CHAR formula to other cells, we have,