This will convert the data in cell A2 in uppercase. To apply the same formula to all other values in Column B, select cell B2 and take your cursor to the bottom-right corner of the cell.