Use CODE Function to Find Position Number of Letter in #microsoft #excel #short

preview_player
Показать описание
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
Рекомендации по теме
Комментарии
Автор

64 kis liye use Kiye hain, English alphabet 26 hote hain😢

ShamshadKhan-ikzy