View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.