Discussion Groups Home

Title Text function =PROPER(A3) not working? in Excel General Questions

12/9/2007 6:37 AM PST

Question

	I dont understand why I cannot clen up a worksheet with various upper and lower case structure to the correct "Title Case"? I have a column (A) of mixed upper and lower case words and next to that column I create a new column (B). In that new column (B) I enter my =PROPER(A3) in the cell next to the one to be corrected and nothing? What am I doing wrong or am I missing something? -- LarryW

Was this post helpful to you?

Top

Niek Otten

12/9/2007 6:52 AM PST

Hi Larry,

That should work. What do you have in A3 and what appears in B3?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"LarryW" <lwerline@metromedicalusa.com> wrote in message news:13BEC5ED-E666-473C-99BF-82DD67353FE5@microsoft.com...
|I dont understand why I cannot clen up a worksheet with various upper and
| lower case structure to the correct "Title Case"? I have a column (A) of
| mixed upper and lower case words and next to that column I create a new
| column (B). In that new column (B) I enter my =PROPER(A3) in the cell next
| to the one to be corrected and nothing? What am I doing wrong or am I
| missing something?
| --
| LarryW

Was this post helpful to you?

Top

LarryW

12/9/2007 6:25 PM PST

Hi Niek

What I have in Column A is all the names that are in mixed case starting
with A3. I instered a new Column to the right and that is now Column B. I
moved to Column B in cell 3 "B3". I went and entered the formula in the top
formula bar as =PROPER(A3) The same appeared in (B3) and I tapped enter.
After doing so, the name did not appear in "B3" as corrected? all the was in
B3 was: =PROPER(A3) and nothing more? Am I doing something wrong? I am
using WindowsXP, Excel 2003.
--
LarryW

"Niek Otten" wrote:

> Hi Larry,
>
> That should work. What do you have in A3 and what appears in B3?
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "LarryW" <lwerline@metromedicalusa.com> wrote in message news:13BEC5ED-E666-473C-99BF-82DD67353FE5@microsoft.com...
> |I dont understand why I cannot clen up a worksheet with various upper and
> | lower case structure to the correct "Title Case"? I have a column (A) of
> | mixed upper and lower case words and next to that column I create a new
> | column (B). In that new column (B) I enter my =PROPER(A3) in the cell next
> | to the one to be corrected and nothing? What am I doing wrong or am I
> | missing something?
> | --
> | LarryW
>
>
>

Was this post helpful to you?

Top

Dave Peterson

12/9/2007 6:36 PM PST

Answer

If you're seeing the formula itself, then it could be a couple of things.

#1. You could be looking at formulas.
Tools|Options|View tab|Uncheck Formulas
(in xl2003)
(or hit ctrl-` (control-backquote to the left of the 1/! key on my USA keyboard)

#2. The cell could be formatted as text.
Select the cell
Format|Cells|Number Tab|Choose General (or anything but Text)
Then hit F2, then Enter to tell excel to reevaluate your entry (the formula)

LarryW wrote:
>
> Hi Niek
>
> What I have in Column A is all the names that are in mixed case starting
> with A3. I instered a new Column to the right and that is now Column B. I
> moved to Column B in cell 3 "B3". I went and entered the formula in the top
> formula bar as =PROPER(A3) The same appeared in (B3) and I tapped enter.
> After doing so, the name did not appear in "B3" as corrected? all the was in
> B3 was: =PROPER(A3) and nothing more? Am I doing something wrong? I am
> using WindowsXP, Excel 2003.
> --
> LarryW
>
> "Niek Otten" wrote:
>
> > Hi Larry,
> >
> > That should work. What do you have in A3 and what appears in B3?
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> > Microsoft MVP - Excel
> >
> > "LarryW" <lwerline@metromedicalusa.com> wrote in message news:13BEC5ED-E666-473C-99BF-82DD67353FE5@microsoft.com...
> > |I dont understand why I cannot clen up a worksheet with various upper and
> > | lower case structure to the correct "Title Case"? I have a column (A) of
> > | mixed upper and lower case words and next to that column I create a new
> > | column (B). In that new column (B) I enter my =PROPER(A3) in the cell next
> > | to the one to be corrected and nothing? What am I doing wrong or am I
> > | missing something?
> > | --
> > | LarryW
> >
> >
> >

--

Dave Peterson

Was this post helpful to you?

Top

LarryW

12/9/2007 7:15 PM PST

Thank you Dave :o) The first one was the fix! U Da Man!
--
LarryW

"Dave Peterson" wrote:

> If you're seeing the formula itself, then it could be a couple of things.
>
> #1. You could be looking at formulas.
> Tools|Options|View tab|Uncheck Formulas
> (in xl2003)
> (or hit ctrl-` (control-backquote to the left of the 1/! key on my USA keyboard)
>
> #2. The cell could be formatted as text.
> Select the cell
> Format|Cells|Number Tab|Choose General (or anything but Text)
> Then hit F2, then Enter to tell excel to reevaluate your entry (the formula)
>
> LarryW wrote:
> >
> > Hi Niek
> >
> > What I have in Column A is all the names that are in mixed case starting
> > with A3. I instered a new Column to the right and that is now Column B. I
> > moved to Column B in cell 3 "B3". I went and entered the formula in the top
> > formula bar as =PROPER(A3) The same appeared in (B3) and I tapped enter.
> > After doing so, the name did not appear in "B3" as corrected? all the was in
> > B3 was: =PROPER(A3) and nothing more? Am I doing something wrong? I am
> > using WindowsXP, Excel 2003.
> > --
> > LarryW
> >
> > "Niek Otten" wrote:
> >
> > > Hi Larry,
> > >
> > > That should work. What do you have in A3 and what appears in B3?
> > >
> > > --
> > > Kind regards,
> > >
> > > Niek Otten
> > > Microsoft MVP - Excel
> > >
> > > "LarryW" <lwerline@metromedicalusa.com> wrote in message news:13BEC5ED-E666-473C-99BF-82DD67353FE5@microsoft.com...
> > > |I dont understand why I cannot clen up a worksheet with various upper and
> > > | lower case structure to the correct "Title Case"? I have a column (A) of
> > > | mixed upper and lower case words and next to that column I create a new
> > > | column (B). In that new column (B) I enter my =PROPER(A3) in the cell next
> > > | to the one to be corrected and nothing? What am I doing wrong or am I
> > > | missing something?
> > > | --
> > > | LarryW
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

Was this post helpful to you?

Top

supoch14

8/28/2008 7:39 PM PST

"Dave Peterson" wrote:

> If you're seeing the formula itself, then it could be a couple of things.
>
> #1. You could be looking at formulas.
> Tools|Options|View tab|Uncheck Formulas
> (in xl2003)
> (or hit ctrl-` (control-backquote to the left of the 1/! key on my USA keyboard)
>
> #2. The cell could be formatted as text.
> Select the cell
> Format|Cells|Number Tab|Choose General (or anything but Text)
> Then hit F2, then Enter to tell excel to reevaluate your entry (the formula)
>
> LarryW wrote:
> >
> > Hi Niek
> >
> > What I have in Column A is all the names that are in mixed case starting
> > with A3. I instered a new Column to the right and that is now Column B. I
> > moved to Column B in cell 3 "B3". I went and entered the formula in the top
> > formula bar as =PROPER(A3) The same appeared in (B3) and I tapped enter.
> > After doing so, the name did not appear in "B3" as corrected? all the was in
> > B3 was: =PROPER(A3) and nothing more? Am I doing something wrong? I am
> > using WindowsXP, Excel 2003.
> > --
> > LarryW
> >
> > "Niek Otten" wrote:
> >
> > > Hi Larry,
> > >
> > > That should work. What do you have in A3 and what appears in B3?
> > >
> > > --
> > > Kind regards,
> > >
> > > Niek Otten
> > > Microsoft MVP - Excel
> > >
> > > "LarryW" <lwerline@metromedicalusa.com> wrote in message news:13BEC5ED-E666-473C-99BF-82DD67353FE5@microsoft.com...
> > > |I dont understand why I cannot clen up a worksheet with various upper and
> > > | lower case structure to the correct "Title Case"? I have a column (A) of
> > > | mixed upper and lower case words and next to that column I create a new
> > > | column (B). In that new column (B) I enter my =PROPER(A3) in the cell next
> > > | to the one to be corrected and nothing? What am I doing wrong or am I
> > > | missing something?
> > > | --
> > > | LarryW
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>

Was this post helpful to you?

Top

Olayah

5/13/2008 8:20 AM PST

"LarryW" wrote:

> I dont understand why I cannot clen up a worksheet with various upper and
> lower case structure to the correct "Title Case"? I have a column (A) of
> mixed upper and lower case words and next to that column I create a new
> column (B). In that new column (B) I enter my =PROPER(A3) in the cell next
> to the one to be corrected and nothing? What am I doing wrong or am I
> missing something?
> --
> LarryW

Was this post helpful to you?

Top

David Biddulph

5/13/2008 8:54 AM PST

What do you mean "... and nothing" ?

If the cell is displaying the formula, rather than the result, you've
probably preformatted the cell as Text. Format it as General, then re-enter
the formula.

If you are not seeing the formula, but you are not seeing the appropriate
result, check that you haven't got the calculation mode set to Manual.
Tools/ Options/ Calculation, and make sure it's set to Automatic.
--
David Biddulph

"Olayah" <Olayah@discussions.microsoft.com> wrote in message
news:36772E38-2514-420E-8522-731DA6D0C2AD@microsoft.com...
>
>
> "LarryW" wrote:
>
>> I dont understand why I cannot clen up a worksheet with various upper and
>> lower case structure to the correct "Title Case"? I have a column (A) of
>> mixed upper and lower case words and next to that column I create a new
>> column (B). In that new column (B) I enter my =PROPER(A3) in the cell
>> next
>> to the one to be corrected and nothing? What am I doing wrong or am I
>> missing something?
>> --
>> LarryW

Was this post helpful to you?

Top

supoch14

8/28/2008 7:39 PM PST

Was this post helpful to you?

Top

	Return to Microsoft Communities		Notify me of replies