How do I change from all caps to proper case? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Tom III 2/25/2005 2:03 PM PST   Question   I purchased a rather large list that is in all caps (in .txt format). Is there a function that will allow Excel (or any other Office product) to automatically change the names to proper case? I will need to save the results back in .txt format to import into a contact management program.     Was this post helpful to you?         Reply |   Top           JE McGimpsey 2/25/2005 2:14 PM PST   Answer   take a look here: http://www.mvps.org/dmcritchie/excel/proper.htm#proper In article <50E13903-CB21-4B2E-A3B1-EBEE5FFF2F17@microsoft.com>, "Tom III" <Tom III@discussions.microsoft.com> wrote: > I purchased a rather large list that is in all caps (in .txt format). Is > there a function that will allow Excel (or any other Office product) to > automatically change the names to proper case? I will need to save the > results back in .txt format to import into a contact management program.     Was this post helpful to you?         Reply |   Top           anonymous@discussions.microsoft.com 2/25/2005 2:59 PM PST   =propoer(A1) in excel or open in Word andFormat>Change Case >-----Original Message----- >I purchased a rather large list that is in all caps (in .txt format). Is >there a function that will allow Excel (or any other Office product) to >automatically change the names to proper case? I will need to save the >results back in .txt format to import into a contact management program. >. >     Was this post helpful to you?         Reply |   Top           Britty 6/16/2005 4:37 PM PST   I have tried this and it doesn't seem to work. Where do I put the =proper(A1) ... in the column marked A1 or for the whole column? "anonymous@discussions.microsoft.com" wrote: > =propoer(A1) in excel > or open in Word andFormat>Change Case > >-----Original Message----- > >I purchased a rather large list that is in all caps > (in .txt format). Is > >there a function that will allow Excel (or any other > Office product) to > >automatically change the names to proper case? I will > need to save the > >results back in .txt format to import into a contact > management program. > >. > > >     Was this post helpful to you?         Reply |   Top           George Nicholson 6/16/2005 6:11 PM PST   - Make a backup! - Add a new column (lets say it's column B) - In B1 type: = Proper(A1) - B1 should now reflect how you want the data in A1 to appear - Copy B1 down as far as your list goes. Calculate (F9), if necessary. - Select Column B and Copy it. - With Column B still selected: Edit>PasteSpecial>Values (this replaces the formula with the formula results) - After verifying that Column B is what you want and has no loss of data, you can delete Column A HTH, -- George Nicholson Remove 'Junk' from return address. "Britty" <Britty@discussions.microsoft.com> wrote in message news:76874B73-5928-4646-AD76-85D2A52CC1C3@microsoft.com... >I have tried this and it doesn't seem to work. > Where do I put the =proper(A1) ... in the column marked A1 or for the > whole > column? > > "anonymous@discussions.microsoft.com" wrote: > >> =propoer(A1) in excel >> or open in Word andFormat>Change Case >> >-----Original Message----- >> >I purchased a rather large list that is in all caps >> (in .txt format). Is >> >there a function that will allow Excel (or any other >> Office product) to >> >automatically change the names to proper case? I will >> need to save the >> >results back in .txt format to import into a contact >> management program. >> >. >> > >>     Was this post helpful to you?         Reply |   Top           JustinLabenne 6/17/2005 12:33 AM PST   Ivan Moala has a "Case Change" utility available that works very nice here: http://www.xcelfiles.com/Downloads_01.html Also ASAP Utilities has an option available for for case changing here: http://www.asap-utilities.com/ Nothing to do on your part except download the "free" add-in, save it in your library path, then let the utility do the work. Then just copy / paste back to .txt format, or whatever is needed. If this is a procedure you do often, these add-ins are a real time saver when it comes to changing to Proper/Lower/All Caps -- JustinLabenne     Was this post helpful to you?         Reply |   Top           PlayingToAudienceOfOne 5/29/2007 9:53 PM PST   Copy the following macro: Sub Change_Case() Dim ocell As Range Dim Ans As String Ans = Application.InputBox("Type in Letter" & vbCr & _ "(L)owercase, (U)ppercase, (S)entence, (T)itles ") If Ans = "" Then Exit Sub For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2) Select Case UCase(Ans) Case "L": ocell = LCase(ocell.Text) Case "U": ocell = UCase(ocell.Text) Case "S": ocell = UCase(Left(ocell.Text, 1)) & _ LCase(Right(ocell.Text, Len(ocell.Text) - 1)) Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text) End Select Next End Sub "Tom III" wrote: > I purchased a rather large list that is in all caps (in .txt format). Is > there a function that will allow Excel (or any other Office product) to > automatically change the names to proper case? I will need to save the > results back in .txt format to import into a contact management program.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies