Forum Discussion
Solved
fUNCTION ALLOWING to check the value of a letter which as the first position in a word
Hi Guys, i'm searching in excel the function which allows me to check the the value of a letter which has got the first position in a word. can you help me please ?
As a comment
=CODE(LEFT(A2,1))
and
=CODE(A2)
both return the same value.
I personally always prefer to use UNICODE(), but in most cases that doesn't matter.
That could be the basis for other manipulations. For example, to check if first character is alphabet character or not (only for English)
=CHAR(BITXOR(CODE(A2),32))=CHAR(CODE(A2))
As a comment
=CODE(LEFT(A2,1))
and
=CODE(A2)
both return the same value.
I personally always prefer to use UNICODE(), but in most cases that doesn't matter.
That could be the basis for other manipulations. For example, to check if first character is alphabet character or not (only for English)
=CHAR(BITXOR(CODE(A2),32))=CHAR(CODE(A2))
Thank you so much Sergei