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
|
|||
|
|||
=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
|
|||
|
|||
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 |