filmov
tv
Use CODE Function to Find Position Number of Letter in #microsoft #excel #short
![preview_player](https://i.ytimg.com/vi/CB3UFaRohGw/maxresdefault.jpg)
Показать описание
How to Find Position Number of Letter Using the CODE Function in Microsoft Excel.
In this video, I use the CODE function to find the position number of the letter in MS Excel.
What is the CODE function in Excel?
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
Syntax:
CODE(text)
text: is the text for which you want the code of the first character in the text string.
Formula in this video:
=CODE(A3)-64
Table example:
-----------------------------------
Letter Position
-----------------------------------
B 2
A 1
C 3
D 4
E 5
F 6
G 7
H 8
I 9
J 10
Y 25
Z 26
-----------------------------------
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
♥️♥️📖♥️♥️
-----------------------------------
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge #newexcel #microsoftoffice #bestlearning
@RachanaChiv
-----------------------------------
Prepared by: Dr. Rachana Chiv
In this video, I use the CODE function to find the position number of the letter in MS Excel.
What is the CODE function in Excel?
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
Syntax:
CODE(text)
text: is the text for which you want the code of the first character in the text string.
Formula in this video:
=CODE(A3)-64
Table example:
-----------------------------------
Letter Position
-----------------------------------
B 2
A 1
C 3
D 4
E 5
F 6
G 7
H 8
I 9
J 10
Y 25
Z 26
-----------------------------------
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
♥️♥️📖♥️♥️
-----------------------------------
#msexcel #pivottable #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #shortvideo #shortfeed #short #shorts #shortsviral #shortsyoutube #share #knowledge #knowledgesharing #exceleasy #excelformula #exceleducation #excelknowledge #newexcel #microsoftoffice #bestlearning
@RachanaChiv
-----------------------------------
Prepared by: Dr. Rachana Chiv
Комментарии