Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=proper
I have a sheet with a bunch or columns. The values are in upper, lower and
combined case. Some are also numbers. I want to change all valuse to: first letter capital and the rest lowercase. I have messed around with the =proper function. The only way I can get this to work is if I put the function in a blank cell and then only do one cell at a time. Is there away to do the whole sheet at once and replace the current contents of each cell with the correct case? Thanks! Darren MCP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=PROPER() | Excel Discussion (Misc queries) | |||
Not Proper! | Excel Worksheet Functions | |||
proper | Excel Discussion (Misc queries) | |||
=PROPER | Excel Discussion (Misc queries) | |||
=PROPER | Excel Discussion (Misc queries) |