Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |