Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to change small words to capital in excel workbook?

user-image
Question added by ARMAAN BISWAS
Date Posted: 2016/01/28
Irshad Pattasseri Padikkal
by Irshad Pattasseri Padikkal , Engineerin Supervisor , Aldrees Industrial and Trading Company(ALITCO)

By using "upper" function

Example:

=upper(a1)

Younus Mohammed
by 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
by George Changayil Thomas , Accountant , Almulla Group

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

Muhammad Zeeshan Baloch
by Muhammad Zeeshan Baloch , Junior Accounts Executive , Shahnawaz Pvt Ltd

=upper("name")

=upper(reference)

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
by Ubaid sayeed Mohd abdul sayeed , Senior Programmer , Moksha solutions

For excel use the toupper() function.

More Questions Like This