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 , CBK - G&D - AXIS-olutions
Date Posted: 2015/05/30
Ahmed Maher allam
by 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
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

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.