Hi David

Having used a helper column to do your conversion to Upper(), copy the
whole of the column, move cursor to A1 and choose Paste SpecialValues.
You can then delete the helper column.

--
Regards

Roger Govier


"David" wrote in message
...
XP Pro 2oo3 Excel (11.8105.8107) SP2.
I have a column with mixed case. I put in an adjacent column
=UPPER(a2(etc)).
This upped the case as required, however I want to delete the old
mixed case column and use only the new upped case, but when I del,
then both the old contents and the content of the new column go.
What should I do to change case and end up with only one column?
Regards,
Dave.