Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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
Question added by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
Date Posted: 2015/05/30
Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

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
by 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
by Joseph ELIA , Technical support Lead , Inconet Data management

you can press the button ALT and then the number65

ASHOK KUMAR M P
by ASHOK KUMAR M P , Data Entry Operator , District TB Cente, Govt. Health Services, Kerala

We can use insert symbol option to insert all characters.

More Questions Like This