Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get =Clean and =Proper Case to run on all cells in a col
I have 3 columns (K, L, M) that we paste text into from other soucres. The
text that's pasted is sometime all caps, hence the reason for the "Proper Case" Function and additionally the pasted text contains hard returns that need to be remove so that it reads correctly, hence the "Clean" function. I would like for this to happen as soon as the text is pasted into the cell. Thanks for your help in advance, Coyote |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change from upper case to proper case in excel 2002 | Excel Discussion (Misc queries) | |||
Proper Case | Excel Discussion (Misc queries) | |||
excel'03 how to convert a column from upper case to proper case | Excel Discussion (Misc queries) | |||
Excel: How do I change all upper case ss to proper case? | Excel Worksheet Functions | |||
Changing Upper case to Proper Case | Excel Worksheet Functions |