Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use the "Proper" function? The instructions are vague.
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? |
#2
|
|||
|
|||
No you would enter this function in any cell BUT A2. For example, if A2
contains the value "billy BoB thoRton" as you said, then placing the function =PROPER(A2) into cell A3 would output "Billy Bob Thorton" Does that help? -- Regards, DaveB "Polly" wrote: 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? |
#3
|
|||
|
|||
would the function be: =Proper(a2) - YES
would I enter this function in cell A2 - NO You must enter the function in an empty cell "Polly" wrote: 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? |
#4
|
|||
|
|||
Yes, thank you.
Polly "DaveB" wrote: No you would enter this function in any cell BUT A2. For example, if A2 contains the value "billy BoB thoRton" as you said, then placing the function =PROPER(A2) into cell A3 would output "Billy Bob Thorton" Does that help? -- Regards, DaveB "Polly" wrote: 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? |
#5
|
|||
|
|||
As the earlier posters have demonstrated, you have to use it (please
excuse me, and I'll never do this again until the next time) proper-ly. |
#6
|
|||
|
|||
lol
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions |