ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   trying to change Proper function results to text? (https://www.excelbanter.com/excel-worksheet-functions/106769-trying-change-proper-function-results-text.html)

Arlene

trying to change Proper function results to text?
 
I have used the Proper function to get a column of "all upper case" last
names converted to a new column of properly capitalized names (only first
letter capital). My problem is trying to copy the result column somewhere as
text and not as function results.

Dave F

trying to change Proper function results to text?
 
Copy--paste special--values
--
Brevity is the soul of wit.


"Arlene" wrote:

I have used the Proper function to get a column of "all upper case" last
names converted to a new column of properly capitalized names (only first
letter capital). My problem is trying to copy the result column somewhere as
text and not as function results.



All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com