ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How can I insert the capital letter A in any cell without pressing on the button A on my keyboard or the screen keyboard?

user-image
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
تاريخ النشر: 2015/05/30
Ahmed Maher allam
من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

The answer is :  =char(65)

 

because a small has decimal number97 and the capital A has decimal number65

and the formula char changes the decimal and convert it to binary then to ascii

Fakhar Majeed
من قبل Fakhar Majeed , Civil Draftsman , Irrigation Department

You Can Click on Column A and go on "Name Box" where Shown A select by Mouse, Copy and Paste in any Cell

Joseph ELIA
من قبل Joseph ELIA , Technical support Lead , Inconet Data management

you can press the button ALT and then the number65

ASHOK KUMAR M P
من قبل ASHOK KUMAR M P , Data Entry Operator , District TB Cente, Govt. Health Services, Kerala

We can use insert symbol option to insert all characters.

المزيد من الأسئلة المماثلة