| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i return to normal text from =PROPER(cell)
hello, I have converted some cells from lowercase to uppercase using
the =PROPER formula (a list of countries that is). How do i reconvert back to 'normal' text. I tried deleting the =PROPER prefix and leaving just (A1) etc but then this is not correct as it shows up as A1, A2 etc in the formula bar. It should just show belgium, denmark, italy etc - jut normal text! thanks all, really appreciate the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup a text cell and return text | Excel Discussion (Misc queries) | |||
| How do I change text to proper when text is already in upper? | New Users to Excel | |||
| How can I change text to proper text in multiple cells. | Excel Discussion (Misc queries) | |||
| Embedding a reference in a cell with normal text. | Excel Worksheet Functions | |||
| Proper text | Excel Discussion (Misc queries) | |||
Threaded Mode
