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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i return to normal text from =PROPER(cell)
Use =A1, then copy all the cells, then do editpaste special and paste as
values -- Regards, Peo Sjoblom "showsomeidnow" wrote in message ups.com... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i return to normal text from =PROPER(cell)
Peo Sjoblom, thanks so much for that quick reply. you are very kind -
it worked perfectly! have a nice weekend also :) thanks again. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i return to normal text from =PROPER(cell)
Hi,
Change the case of text Let's say you want to convert text from uppercase to lowercase or from lowercase to proper case to make it more readable. To change the case of text, use the UPPER, LOWER, or PROPER functions. Formula Description (Result) =UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO) =LOWER(A2) Changes text to all lowercase (nancy davolio) =PROPER(A2) Changes text to Title Case (Nancy Davolio) Challa Prabhu "showsomeidnow" wrote: 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. |
Reply |
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) |