| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change the case in Excel Spreadsheet
Assuming you have text in A1 like john smith
In B1 enter =PROPER(A1) Returns John Smith Gord Dibben MS Excel MVP On Mon, 30 Oct 2006 13:16:02 -0800, hornbss wrote: I have ready the posts regarding this subject. I'm an idiot evidentally. Actually, i've never done this before. I've tried entering the =PROPER(text) formula, nothing happens. I've tried copying to VBA (which I don't even know what any of this means) nothing happens. What is the quickest way to find a step by step solution for DUMMIES????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW CAN I CONVERT A NUM IN WORDS (EXCEL) | Excel Discussion (Misc queries) | |||
| how to use spellnumber formula | Excel Worksheet Functions | |||
| spell number | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
Hybrid Mode
