How do I delete a column that has been used for a function? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              DorianG 1/5/2007 6:00 AM PST   Question   I have just learned out how to use functions but still need some help please. I have just used the PROPER function to convert a column of 11000 names from all capital letters to the normal first letter capital with the rest being lower case. I now want to delete the original column, but when I do the "PROPER" column says REF#. How do I solve this problem?     Was this post helpful to you?         Reply |   Top           John Bundy 1/5/2007 6:12 AM PST   Answer   Select the column you just made, then right-click and copy then Paste Special and select Values. That should do it for you -- -- -John Please rate when your question is answered to help us and others know what is helpful. "DorianG" <DorianG@discussions.microsoft.com> wrote in message news:E82A4018-7BEC-4326-AB69-0E77DC1222F8@microsoft.com... >I have just learned out how to use functions but still need some help >please. > I have just used the PROPER function to convert a column of 11000 names > from > all capital letters to the normal first letter capital with the rest being > lower case. I now want to delete the original column, but when I do the > "PROPER" column says REF#. How do I solve this problem?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies