char(number)

[GN0001]

How can we find what is the Char(number) of invisible characters in a cell?

Thanks,

GGGGG

 

[aparvez007]

Hi GGGGG,


You can use Code formula to the invisible Characters.


Regards,

Pavi

 

[Marc L]

Hi !   Two ways :


      - By a formula in a cell.

        For example, the cell is F5 and you want the code of the fourth character :

          =CODE(MID($F$5,4,1)) 


      - By a VBA code :

[pre]Sub CellCharCodes()
S = ActiveCell

For N = 1 To Len(S)
C = Mid(S, N, 1)
T = T & Format(N, "@@  :   ") & C & Format(Asc(C), "   @@@") & vbLf
Next

MsgBox T
End Sub

[/pre]
        Select first the cell in the worksheet and after execute the sub …

 

[GN0001]

Thank you very much.

Regards,

GGGGG