Thread: Use of UPPER()
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 1
Default Use of UPPER()

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.