|
| 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 |
|
#11
April 25th, 2006, 02:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the case from all caps to proper for names I have in columns E, F, G?
I'm really bummin on this one. -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=535552 
|
|
#12
April 25th, 2006, 02:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
The format of cells F1 to F3 is probably set to Text, change this to General, then on each of the cells, press F2 to edit, then press Return. -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#13
April 25th, 2006, 02:53 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
The format of cells F1 to F3 is probably set to Text, change this to General, then on each of the cells, press F2 to edit, then press Return. -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#14
April 25th, 2006, 05:14 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
Gary, unfortunately that whole column is set to general, good thinking though, I hadn't checked that. Any other ideas? -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#15
April 25th, 2006, 05:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
You mean the target cell? After you type it the first time, select the
formula cell. What exactly does it say? Now press F2 and then Enter. Now what does it say exactly? -- Regards, Zack Barresse, aka firefytr "duugg" wrote in message ... Zack, We'll it works if I type the name, erase it, and then re-type it. I want to use this formula on 120 pre-existing cells. If I have to erase it, and then retype it, it will defeat the purpose. Is there a way to use this on pre-existing data. Obviously, even if I have to copy and paste a column into a blank worksheet to do this, it would be okay. If so, do I insert a row above all others to put the formula in just to correct the text entries below that I want to change the case on? -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#16
April 25th, 2006, 07:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
Zack, Okay, here is exactly what I'm doing Cell F1 contains this =PROPER(E1) Cell E1 (currently blank) I type "john smith" (without the quotes) I press enter and nothing happens, nothing appears on the screen, case stays the same (lower, not proper). Thanks for sticking with this. duugg -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#17
April 25th, 2006, 08:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
F1 should read John Smith
E1 will read the "john smith" you typed into it and will not change. What do you see in F1 after you type john smith in E1 and hit F9 in case you have calculation at manual? Gord On Tue, 25 Apr 2006 13:34:01 -0500, duugg wrote: Zack, Okay, here is exactly what I'm doing Cell F1 contains this =PROPER(E1) Cell E1 (currently blank) I type "john smith" (without the quotes) I press enter and nothing happens, nothing appears on the screen, case stays the same (lower, not proper). Thanks for sticking with this. duugg
|
|
#18
April 25th, 2006, 08:43 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
After typing "john smith" (w/o quotes) in E1 and pressing enter, what
happens with each of the following: (Try first) Hitting F9 Selecting F1, press F2, Enter -- Regards, Zack Barresse, aka firefytr "duugg" wrote in message ... Zack, Okay, here is exactly what I'm doing Cell F1 contains this =PROPER(E1) Cell E1 (currently blank) I type "john smith" (without the quotes) I press enter and nothing happens, nothing appears on the screen, case stays the same (lower, not proper). Thanks for sticking with this. duugg -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#19
April 25th, 2006, 09:02 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
Zack, Nothing, nothing and nothing, no joke. -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=535552
|
|
#20
April 25th, 2006, 09:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change the case from all caps to proper for names I have in columns E, F, G?
Any possibility that text format colour is set up as white, so that it's not
visible?? vcard "duugg" wrote in message ... Zack, Nothing, nothing and nothing, no joke. -- *** Posted via a free Usenet account from http://www.teranews.com ***
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I change from all caps to proper case? | Tom III | General Discussion | 6 | May 30th, 2007 05:54 AM |
| Conversion of Numercials to Figure | JAGANNATH | Worksheet Functions | 1 | April 4th, 2006 04:12 PM |
| How can i change this VBA project According to Indian Numeric | Rao Ratan Singh | General Discussion | 1 | April 21st, 2005 07:53 PM |
| chart help please | jvoortman | General Discussion | 7 | September 17th, 2004 01:30 AM |
| Is it possible to filter based on ceel format | ludahen | Worksheet Functions | 4 | June 9th, 2004 09:19 PM |
Linear Mode
