ExcelBanter - Use of UPPER()

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Use of UPPER() (https://www.excelbanter.com/excel-programming/376252-use-upper.html)

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.

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.