View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.misc
Zack Barresse
 
Posts: n/a
Default 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