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.
|