ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Title Text function =PROPER(A3) not working? (https://www.excelbanter.com/excel-discussion-misc-queries/169010-title-text-function-%3Dproper-a3-not-working.html)

LarryW

Title Text function =PROPER(A3) not working?
 
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

Niek Otten

Title Text function =PROPER(A3) not working?
 
Hi Larry,

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"LarryW" wrote in message ...
|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



LarryW

Title Text function =PROPER(A3) not working?
 
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" wrote in message ...
|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

Title Text function =PROPER(A3) not working?
 
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" wrote in message ...
|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

LarryW

Title Text function =PROPER(A3) not working?
 
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" wrote in message ...
|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


Olayah

Title Text function =PROPER(A3) not working?
 


"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


David Biddulph[_2_]

Title Text function =PROPER(A3) not working?
 
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" wrote in message
...


"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




supoch14

Title Text function =PROPER(A3) not working?
 


"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


supoch14

Title Text function =PROPER(A3) not working?
 


"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" wrote in message ...
|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



All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com