Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula results to actual value
This is very basic but I cannot find the answer in the help and I am new
to Excel 2002. I have a column of text that was entered in all caps and that I wanted to change to proper caps. So, I used the formula "=PROPER(...)" to change the column of text from all caps to title case. That worked fine. The results were produced the next column over. But what I really want to do is replace the original column that contained the text in all caps with the changed text. How do I change the column of "results" of the formula into actual "real text" so I can copy them over and replace the original all caps text? Thank you. (Hope I am clear) Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula results to actual value
"Jeff" wrote in message
... This is very basic but I cannot find the answer in the help and I am new to Excel 2002. I have a column of text that was entered in all caps and that I wanted to change to proper caps. So, I used the formula "=PROPER(...)" to change the column of text from all caps to title case. That worked fine. The results were produced the next column over. But what I really want to do is replace the original column that contained the text in all caps with the changed text. How do I change the column of "results" of the formula into actual "real text" so I can copy them over and replace the original all caps text? Thank you. (Hope I am clear) Jeff Just copy the "results" column, select the "capitals" column and use Paste Special Values |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula results to actual value
Hi Jeff,
Simply highlight the values in the "Proper" column and then use Paste Special to paste them "As Values" over top capitalized versions. Pastel "Jeff" wrote: This is very basic but I cannot find the answer in the help and I am new to Excel 2002. I have a column of text that was entered in all caps and that I wanted to change to proper caps. So, I used the formula "=PROPER(...)" to change the column of text from all caps to title case. That worked fine. The results were produced the next column over. But what I really want to do is replace the original column that contained the text in all caps with the changed text. How do I change the column of "results" of the formula into actual "real text" so I can copy them over and replace the original all caps text? Thank you. (Hope I am clear) Jeff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula results to actual value
Stephen wrote:
"Jeff" wrote in message ... This is very basic but I cannot find the answer in the help and I am new to Excel 2002. I have a column of text that was entered in all caps and that I wanted to change to proper caps. So, I used the formula "=PROPER(...)" to change the column of text from all caps to title case. That worked fine. The results were produced the next column over. But what I really want to do is replace the original column that contained the text in all caps with the changed text. How do I change the column of "results" of the formula into actual "real text" so I can copy them over and replace the original all caps text? Thank you. (Hope I am clear) Jeff Just copy the "results" column, select the "capitals" column and use Paste Special Values Thank you. Too simple ...... ! Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Formula Results to Actual Data Values | Excel Discussion (Misc queries) | |||
how do i copy the actual text of a formula? | Excel Discussion (Misc queries) | |||
what is the 1 minus in this formula actual doing | Excel Worksheet Functions | |||
Display results of formulas not the actual formula | Excel Discussion (Misc queries) | |||
formula for month(s) prior to actual | Excel Worksheet Functions |