Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date de publication: 2015/05/30
Ahmed Maher allam
par 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
par 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
par Joseph ELIA , Technical support Lead , Inconet Data management

you can press the button ALT and then the number65

ASHOK KUMAR M P
par 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