|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 19th, 2007, 07:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
decap names from transferred data
How do I decap names that come across in all capital letters when I transfer
data. I am usinga csv format. 
|
|
#2
July 19th, 2007, 07:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
decap names from transferred data
have a look at 'Proper' in help.
Mike "goathead" wrote: How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
|
|
#3
July 19th, 2007, 08:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
decap names from transferred data
Once the data is in Excel it is no longer csv format.
I would use the PROPER function for names. GORD DIBBEN in A1...............in B1 enter =PROPER(A1) to return Gord Dibben Gord Dibben MS Excel MVP On Thu, 19 Jul 2007 11:26:02 -0700, goathead wrote: How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
|
|
#4
May 11th, 2010, 04:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
decap names from transferred data
Hi,
I just gave this a try, but I cant' seem to get the formula to apply. I have a column (C) of names in all caps. In a blank cell, I typed =PROPER(C2:C112) and then hit enter but it keeps giving me error messages. Any help? Thanks! "Gord Dibben" wrote: Once the data is in Excel it is no longer csv format. I would use the PROPER function for names. GORD DIBBEN in A1...............in B1 enter =PROPER(A1) to return Gord Dibben Gord Dibben MS Excel MVP On Thu, 19 Jul 2007 11:26:02 -0700, goathead wrote: How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
|
|
#5
May 11th, 2010, 04:49 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
decap names from transferred data
PROPER won't work with multiple cells.
=PROPER(C1) in D1 then copy down by double-clicking on the fill handle of D1 Then select column D and copypaste specialvaluesokesc Delete column C Gord On Tue, 11 May 2010 08:28:05 -0700, Attman68 wrote: Hi, I just gave this a try, but I cant' seem to get the formula to apply. I have a column (C) of names in all caps. In a blank cell, I typed =PROPER(C2:C112) and then hit enter but it keeps giving me error messages. Any help? Thanks! "Gord Dibben" wrote: Once the data is in Excel it is no longer csv format. I would use the PROPER function for names. GORD DIBBEN in A1...............in B1 enter =PROPER(A1) to return Gord Dibben Gord Dibben MS Excel MVP On Thu, 19 Jul 2007 11:26:02 -0700, goathead wrote: How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
|
|
#6
May 11th, 2010, 05:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
decap names from transferred data
I wanted to sharpen my question a bit. I'm trying to apply PROPER to my
entire Excel table. Right now, I'm doing one column at a time, but I'd like to find a way to select the entire table and have the PROPER function apply proper text capitalization to any data field that has such text. Is there a way to do that? Thanks! "goathead" wrote: How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
|
|
#7
May 11th, 2010, 05:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
decap names from transferred data
Only with VBA
Sub Proper() Dim Cell As Range Application.ScreenUpdating = False For Each Cell In ActiveSheet.UsedRange Cell.Formula = Application.Proper(Cell.Formula) Next Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Tue, 11 May 2010 09:00:01 -0700, Attman68 wrote: I wanted to sharpen my question a bit. I'm trying to apply PROPER to my entire Excel table. Right now, I'm doing one column at a time, but I'd like to find a way to select the entire table and have the PROPER function apply proper text capitalization to any data field that has such text. Is there a way to do that? Thanks! "goathead" wrote: How do I decap names that come across in all capital letters when I transfer data. I am usinga csv format.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
