How to display all hidden characters in excel?

Question

Visual Basic

There is a line and you need to see what characters it includes (such as a paragraph mark) and whether they are included at all, tell me how to implement it?

Answer 1

displaying encodings in cells for each character
On the sheet, write any text in cell A2
in cell B2, add this formula -

=IF(DLSTR($A$2)>ROW(A2)-ROW($A$2),MID($A$2,ROW(A2)-ROW($A$2)+1,1),"")

In cell C2 add this formula -

=CODE(B2)

drag the contents of B2 and C2 down a few lines