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 small letter a inside any excel cell without using keyboard or 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
Mohammad Basheer abu ahmad
par Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

I think by option - pick from list - after you copy any character

Muhammad Moeen Bhatti
par Muhammad Moeen Bhatti , Cluster Incharge , Premier DLC - A project of Beaconhouse Group

if you don't want to use any keyboard you can enter the small letter with mouse with copy / paste option

Michael Lagunday
par Michael Lagunday , Accounts Assistant , Invest Group Overseas LLC

 It can be done using a copy and paste.

 

 

Ahmed Maher allam
par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

The answer is :  =char(97)

 

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

Donna Angeli Benitez
par Donna Angeli Benitez , Accounting Assistant , Extreme Piling Tech-Doha Qatar

copy the text using the mouse then paste in the excel cell.

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

Select the letter what you want to enter and paste it to ever you want

Said Ibrahim Abdelsalam Rizk
par Said Ibrahim Abdelsalam Rizk , Financial Manager , Modern Power Systems - MPS

Advanced Answer : To write "a" in any cell in any sheet - Just with Mouse Click

1- "Right-Click" on any sheet in excel Workbook

2- From popup menu select "View Code"

3- From left panel named "VBAProject" select "ThisWorkbook"

4- past the following code in the withe space

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)Target.Cells.Value = "a"End Sub

 

 

 

 

هاشم المشارقة
par هاشم المشارقة , Key Account Manager , Advanced United Systems Ltd. ( A member of Taj Holding Group)

It is very advanced tricky, Actually I don't know.

But what about put the pointer at the bottom-left corner and drag to the cell down ?

Abhilash Koturwar
par Abhilash Koturwar , Development Manager , Sobha Realty

copy text from other cell i gues

More Questions Like This