Uppercase

R

Real Dummy

I have no idea what I am doing and only hope someone can help. I a
trying to change lowercase to uppercase AND the formulas I see are
foreign language to me. I had labels in Word and in order to updat
the label list I decided to shift the labels to excel, but all of
sudden it started to convert my uppercase to lowercase and I can't mak
it stop. I really don't want to type all of the names again. Help,
remian a Real Dummy Thanks in advance
 
F

Fred Smith

Let's assume your names are in column A.

Insert a column next to A by right-clicking on column B and choosing Insert.

In B1, type =UPPER(A1)

This should display your name entirely in upper case.

Copy this formula down the entire column (click on the small square box in the
bottom right hand corner, and drag it down to the bottom of your column).

You should now have all your names in upper case.
 
Top