Re: [libreoffice-users] regular expression for calc

Did the OP get this working. I have it working with =COUNTIF(SEARCH("\b"&$G$37&"\b",E37:E39),">1") $G$37 contains the search term with word boundaries. E37:E39 is the range I am searching. Enter into the cell where you want the answer =COUNTIF(SEARCH("\b"&$G$37&"\b",E37:E39),">1") and press

Re: [libreoffice-users] sort order

Got them! Thank you so much for these, will take me a bit of time to absorb but i'm sure they'll be useful. /Gary On Mon, 13/3/17, Michael D. Setzer II wrote: Subject: Re: [libreoffice-users] sort order To:

Re: [libreoffice-users] regular expression for calc

Hi Regina, Thank you, yes, that's cracked it. (*so* many pitfalls for the unwary!) Best Gary On Sun, 12/3/17, Regina Henschel wrote: Subject: Re: [libreoffice-users] regular expression for calc To:

Re: [libreoffice-users] sort order

Wow, yes, that sounds the sort of thing. It would need to be customisable, I'm not sure that the sequence used for the transliteration of hieroglyphs would necesarily be catered for  Gary On Sun, 12/3/17, leleu wrote: