|
| 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
January 20th, 2005, 11:23 PM
|
|||
|
|||
=PROPER
Using Excel 2003. Have downloaded info and it was downloaded in all caps.
Have tried to use the =PROPER formulat but it doesn't work. If I go to a separate cell in the spreadsheet referencing a specific cell it works. How can I change in one worksheet all caps to PROPER ? 
|
|
#2
January 21st, 2005, 01:46 PM
|
|||
|
|||
|
How are you using =PROPER?
It's designed purpose is to be used in a different cell --- for example your information is in Cell C5 then in D5 you may put =PROPER(C5). Then in D5, you would have the information from C5 with PROPER capitalization "Snowcap" wrote in message ... : Using Excel 2003. Have downloaded info and it was downloaded in all caps. : Have tried to use the =PROPER formulat but it doesn't work. If I go to a : separate cell in the spreadsheet referencing a specific cell it works. How : can I change in one worksheet all caps to PROPER ?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| problem with =PROPER | Kimberly Wood | Setting up and Configuration | 1 | February 24th, 2004 11:33 PM |
| =PROPER | Mike Cotham | Worksheet Functions | 2 | September 24th, 2003 08:52 PM |
Linear Mode
