Very slick Andreas.
tc
Andreas Saeger wrote:
<snip>
Test with two formulae in sheet cells:
=shSep --> "!" in Excel, "." (dot) in Calc
=xlEsc --> "~" in Excel, "" (empty string) in Calc
Change your formulae to COUNTIF (range,"A"& xlEsc &"*")
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
