Question

How to fill a column with capital letters in excel?

Answer 1

use=UPPER(A2)in cases where you need to convert text to uppercase,replacing A2 with the appropriate cell reference.now fill down the formula in the new column.the quickest way to do this by selecting cell B2 and then double clicking the small black square that appears in the lowere right corner of the cell.