In a helper column, use the upper function. Ex: insert column B, then in B1
enter the function =upper(a1). Copy that formula down through the rest of
column B. Now copy column B, select column A and Edit > Paste Special,
select Values and click OK. Then delete column B.
Please save before making significant changes! And, personally, I'd ask if
you really, really, really, want to convert to upper case. It's always easy
to convert to upper case as necessary; not so easy to go back (and mixed
case is certainly easier to read).
--Bruce

"WordAlone Network" wrote:

> I need to change name and address from mixed case to uppercase in the cells
> on my Excel spreadsheet - is there a way to do this without retyping
> everything?