How to change small words to capital in excel workbook?

By using "upper" function

Example:

=upper(a1)

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.

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

=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)

For excel use the toupper() function.