Hi Lilbit,
and as you kind quoted part of one of my responses, you now have the
value in two columns. If you simply want to change the
original column or other selection of cells in place you would use
a macro as in http://www.mvps.org/dmcritchie/excel/proper.htm#upper

You select, run macro, and you would be done ...

as opposed to a little dance after using a formula =UPPER(A1), comprised of

Copy column B by selecting it then using Ctrl+C to copy
(optional to select column A if you want the original column changed instead of B)
Edit, Paste special, values
Now you can eliminate whichever column is extraneous

The optional switch in selection to Column A would be if other cells
refer to column A the would no longer reference a cell if you eliminated
that column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lilbit" wrote in message lkaboutsoftware.com...
Thank you very much!! It worked like a charm!!!