ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How to change small words to capital in excel workbook?

user-image
تم إضافة السؤال من قبل ARMAAN BISWAS
تاريخ النشر: 2016/01/28
Irshad Pattasseri Padikkal
من قبل Irshad Pattasseri Padikkal , Engineerin Supervisor , Aldrees Industrial and Trading Company(ALITCO)

By using "upper" function

Example:

=upper(a1)

Younus Mohammed
من قبل Younus Mohammed , Administrative Officer Cum Accountant , RURAL INTEGRATED AND SOCIAL EDUCATION SOCIETY (RISES)

Click Home, click Fill, and then click Down. Note The new column now contains the lowercase version of the text in column A. Note You can also fill cells B2 through B7 by clicking cell B1, and then dragging the fill handle to cell B7. Highlight cells B1 through B7, click Home, and then click Copy.

George Changayil Thomas
من قبل George Changayil Thomas , Accountant , Almulla Group

In Excel WoRkbook,Type formula =UPPER (Cell)..

Muhammad Zeeshan Baloch
من قبل Muhammad Zeeshan Baloch , Junior Accounts Executive , Shahnawaz Pvt Ltd

=upper("name")

=upper(reference)

Hassan Idami
من قبل Hassan Idami

By using  UPPER() function :

For ex :

if the words to change are in the cell A1, So type the following formula in another cell, like A2 :

=UPPER(A1)

Ubaid sayeed Mohd abdul sayeed
من قبل Ubaid sayeed Mohd abdul sayeed , Senior Programmer , Moksha solutions

For excel use the toupper() function.

المزيد من الأسئلة المماثلة