At 03:12 24/10/2008 +0000, Girard Aquino wrote:
I got the new column, ...
Good-oh!
... but I am having difficulty representing characters in the countif(). I am using =COUNTIF(D8:D133;"\").
That will count those cells which contain a backslash and nothing else, of course. Is that what you want? Since my example didn't use any backslashes, I can't guess what you are trying to do.
i tried to replace the formatting of the new column into text, ...
That's unlikely to be your problem, I think. Anything potentially containing a backslash has to be text, doesn't it?
... but can't get the desired result. I know it's probably a problem with my syntax.
Are you trying to search for cells containing a backslash, rather than those consisting of a backslash? That's more complex. Note that the results will depend on your setting at Tools | Options... | OpenOffice.org Calc | Calculate | Enable regular expressions in formulas. And a backslash is a peculiarly confusing character to choose in your scheme (if that is what you have done), since it is also the escape character for regular expressions.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
