Andreas Saeger wrote:
=shSep --> "!" in Excel, "." (dot) in Calc
=xlEsc --> "~" in Excel, "" (empty string) in Calc
Change your formulae to COUNTIF (range,"A"& xlEsc &"*")
Thank you! Very useful work around which I will use on my own sheets in
future.
Still a pity the import filter doesn't do a suitable conversion though;
not all the sheets I use are actually "mine".
Philip
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
