Ask the Community
Ask any professional question and get answers from other specialists.
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 ... See More