Use the =Upper() function. If your data is in columns A to E put in column F
(cell F1) the formula =Upper(A1) and copy the formula to columns G to J and
down the number of rows you require. Then copy columns F to J back to
columns A to E using Pastespecial - Values to remove the formula.

"Jennifer" wrote:

i have rows in an excel workseet that there is some uppercase words and some
lowercase words, and i need to make them all uppercase. I was told the only
way to do this is to cut and paste it into word, and then re cut and paste it
back into excel after making it all caps. I know this is not true, and i know
that there is a way to do it in excel and it shouldnt be this hard for me as
i went to school for it. but i cant figure it out. Can someone please help
me. Thanks!

Jenn