How do I use the "Proper" function? The instructions are vague.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Polly" <Polly@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 17 Aug 2005 10:18:01 -0700

I am trying to use the proper function in a large list. When I try to use the
proper function, the returned result is "0".

If cell A2 contains billy BoB thoRton, would the function be:
=Proper(a2) and would I enter this function in cell A2?
.

Follow-Ups:
- Re: How do I use the "Proper" function? The instructions are vague.
  - From: Blue Hornet
- RE: How do I use the "Proper" function? The instructions are vague.
  - From: Duke Carey
- RE: How do I use the "Proper" function? The instructions are vague.
  - From: DaveB

Prev by Date: Re: If formula evaluating 2 cells contents
Next by Date: copy text from 1 workbook to another by macro
Previous by thread: Sort columns by content
Next by thread: RE: How do I use the "Proper" function? The instructions are vague.
Index(es):
- Date
- Thread

Relevant Pages

Re: Insert "Proper Function" into existing macro
... Here is the code I need the proper function to merge with, ... Private Sub Worksheet_Change(ByVal Target As Excel.Range) ... Dim cell As Range ...
(microsoft.public.excel.worksheet.functions)
Re: Insert "Proper Function" into existing macro
... Private Sub Worksheet_Change(ByVal Target As Excel.Range) ... Here is the code I need the proper function to merge with, ... Dim cell As Range ...
(microsoft.public.excel.worksheet.functions)
Re: Changing the case of text
... The PROPER function is like any other formula. ... The format of the formula ... column next to the first cell that needs to be changed. ...
(microsoft.public.excel.newusers)
Re: how do i change all text case in a given worksheet at one time
... The Proper Function is a cell by cell function like =PROPERand will not ... Dim rng1 As Range, rng2 As Range, bigrange As Range ... Set bigrange = rng2 ...
(microsoft.public.excel.worksheet.functions)
RE: How do I use the "Proper" function? The instructions are vague.
... DaveB ... > I am trying to use the proper function in a large list. ... > If cell A2 contains billy BoB thoRton, ...
(microsoft.public.excel.worksheet.functions)