 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Converting text to uppercase
This is Excel 2000. Cell C2 in a worksheet called 'NOTES' contains '34 West Street, somewhere-in-England' =UPPER ( NOTES!C2 ) is supposed to produce ' 34 WEST STREET, SOMEWHERE-IN-ENGLAND' In fact it gives: #NAME? What is going wrong? Have you spelt UPPER( correctly? There is no space before the open bracket. Hope this helps. Pete > This is Excel 2000. Cell C2 in a worksheet called 'NOTES' > [quoted text clipped - 9 lines] > > What is going wrong? Are you trying to reach the cell from a different sheet? =UPPER ( 'NOTES!C2 ) > This is Excel 2000. Cell C2 in a worksheet called 'NOTES' > [quoted text clipped - 9 lines] > > What is going wrong? Alan, Try getting rid of the space between "UPPER" and "(". That fixed it for me. hth, Doug > This is Excel 2000. Cell C2 in a worksheet called 'NOTES' > [quoted text clipped - 9 lines] > > What is going wrong? try removing the cpases between UPPER and the "(" > This is Excel 2000. Cell C2 in a worksheet called 'NOTES' > [quoted text clipped - 9 lines] > > What is going wrong? Thank you everyone. Alan
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.