I am attempting to use some text functions in a file. They are not working
like they do in another file. Could I have inadvertently flipped some sort
of a switch in this one file?

Quite possibly!

But it's entirely impossible to tell unless you give *some* detail about
what formulae you're using and what "not working" means to you...


In article ,
DogmaDot wrote:

I am attempting to use some text functions in a file. They are not working
like they do in another file. Could I have inadvertently flipped some sort
of a switch in this one file?

"DogmaDot" wrote:

I am attempting to use some text functions in a file. They are not working
like they do in another file. Could I have inadvertently flipped some sort
of a switch in this one file?

I am trying to edit text fields in a .csv file I got via email. I open the
attachment with notepad, save it as a .csv file. I am trying to use the find
function like
Column A
Column B
Row 1 =FIND(" %",B1,1) 2008ApJ%677%37O

Row 2 =text(B2,"000") 2 (a number)

When I type the FIND in the cell then enter, the cell still has the function
in it. Same for the TEXT function.

However when I try the same things in another file the result is fine.
This file was also a .csv file

B C
D (COLS)
Row EXAMPLE RESULT Function
1 43 043
=TEXT(B1,"000")
2 GI4_043001_GW_Lib 4 =FIND("_",B2,1)

Hope you can understand my rather primative attempt to depict a worksheet.

Dot

You've probably formatted A1:A2 as Text, so XL's parser doesn't try to
interpret the formula.

Format the cells as General, and re-enter.

Alternatively, you could have inadvertently typed CTRL-` (on the same
key as the tilde), which toggles the Formulas window Option. Type it
again to see the result of the formula.

In article ,
DogmaDot wrote:

"DogmaDot" wrote:

I am attempting to use some text functions in a file. They are not working
like they do in another file. Could I have inadvertently flipped some sort
of a switch in this one file?

I am trying to edit text fields in a .csv file I got via email. I open the
attachment with notepad, save it as a .csv file. I am trying to use the find
function like
Column A
Column B
Row 1 =FIND(" %",B1,1) 2008ApJ%677%37O

Row 2 =text(B2,"000") 2 (a number)

When I type the FIND in the cell then enter, the cell still has the function
in it. Same for the TEXT function.

However when I try the same things in another file the result is fine.
This file was also a .csv file

B C
D (COLS)
Row EXAMPLE RESULT Function
1 43 043
=TEXT(B1,"000")
2 GI4_043001_GW_Lib 4 =FIND("_",B2,1)

Hope you can understand my rather primative attempt to depict a worksheet.

Dot

J E,

on my (UK-style) keyboard the ` key is the extreme top left (above the
TAB key), whereas the tilde (~) is a shifted # (next to the Enter
key).

Pete

On Jan 14, 4:51*pm, JE McGimpsey wrote:
You've probably formatted A1:A2 as Text, so XL's parser doesn't try to
interpret the formula.

Format the cells as General, and re-enter.

Alternatively, you could have inadvertently typed CTRL-` (on the same
key as the tilde), which toggles the Formulas window Option. Type it
again to see the result of the formula.

In article ,



*DogmaDot wrote:
"DogmaDot" wrote:

I am attempting to use some text functions in a file. *They are not working
like they do in another file. *Could I have inadvertently flipped some sort
of a switch in this one file?

I am trying to edit text fields in a .csv file I got via email. *I open the
attachment with notepad, save it as a .csv file. *I am trying to use the find
function like
* * * * * * * * * * * * * * * * * * Column A * * * * * * * * * * * * *
Column B
*Row 1 * * * * * * * * * *=FIND(" %",B1,1) * * * 2008ApJ%677%37O

*Row 2 * * * * * * * * * * =text(B2,"000") * * * * * * * * * * * 2 (a number)

When I type the FIND in the cell then enter, the cell still has the function
in it. *Same for the TEXT function. *

However when I try the same things in another file the result is fine.
This file was also a .csv file

* * * * * * * *B * * * * * * * * * * * * * * * * * *C * * * * * * * * * * * *
* * * * * * * *D (COLS)
*Row * * * EXAMPLE * * * * * * * * *RESULT * * * * * * * * * * * * Function
1 * * * * 43 * * * * * * * * * * * * * * * * * * * * * 043 * * * * * * * * *
=TEXT(B1,"000")
2 * * * * GI4_043001_GW_Lib * * * * * * *4 * * * * * * * * *=FIND("_",B2,1)

Hope you can understand my rather primative attempt to depict a worksheet.

Dot- Hide quoted text -

- Show quoted text -

Yeah, I should have said "on US keyboards..."

OTOH, with a name like DogmaDot, what are the odds that the OP is *not*
from the US - the last best bastion of dogma...

Thanks for the correction.

In article
,
Pete_UK wrote:

on my (UK-style) keyboard the ` key is the extreme top left (above the
TAB key), whereas the tilde (~) is a shifted # (next to the Enter
key).