HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS? 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              daveylee 11/21/2005 2:29 PM PST   Question   I have a spread sheet with company, name and tel columns. I need to convert the Company column to all caps. ???     Was this post helpful to you?         Reply |   Top           Dave R. 11/21/2005 2:38 PM PST   Answer   use =UPPER(A1) in a helper cell then copy over the originals by pasting values. "daveylee" <daveylee@discussions.microsoft.com> wrote in message news:2A09CEA4-7B8A-48E6-866E-A9E1AD768AEF@microsoft.com... > I have a spread sheet with company, name and tel columns. I need to convert > the Company column to all caps. ???     Was this post helpful to you?         Reply |   Top           daveylee 11/21/2005 3:20 PM PST   Thanks... your suggestion worked just fine. daveylee "Dave R." wrote: > use =UPPER(A1) in a helper cell then copy over the originals by pasting > values. > > "daveylee" <daveylee@discussions.microsoft.com> wrote in message > news:2A09CEA4-7B8A-48E6-866E-A9E1AD768AEF@microsoft.com... > > I have a spread sheet with company, name and tel columns. I need to > convert > > the Company column to all caps. ??? > > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies