Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I insert the small letter a inside any excel cell without using keyboard or screen keyboard?

user-image
Question added by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
Date Posted: 2015/05/30
Mohammad Basheer abu ahmad
by Mohammad Basheer abu ahmad , مشرف كمبيوتر ، الإشراف على الموظفين , قطاع عام

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

Muhammad Moeen Bhatti
by 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
by Michael Lagunday , Accountant , Dubai Camel Racing Club

 It can be done using a copy and paste.

 

 

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

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
by 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
by 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
by 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

 

 

 

 

هاشم المشارقة
by هاشم المشارقة , 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
by Abhilash Koturwar , Development Manager , Sobha Realty

copy text from other cell i gues

More Questions Like This