A macro is a good way to achieve this but could you not simply copy the
=UPPER() formula down in an adjacent column then copy - pastespecial values
back to the first column.

If you want a macro, put a sample of data in here and I'll give you some
code.

Nick


"dplantlady" wrote in message
...
I've used the UPPER function successfully on individual cells, but when I
try
to set up a macro with wildcards or cell references, I get an error or a
circular reference...any ideas? Thanks Excel 2000