Using wildcards in formulas

Hi all,

I’m trying to employ wildcards in formulas in Calc as one can do in Excel but I’ve not been successful. I’d like to know if there is another way to do that.

The formula I’d like to do is: COUNTIF(A1:A5;“A*”). It would return the number of occurences in this range that a word would start with an A. It works good in Excel and in Google Spreadsheets, but it’s not working in Calc. Do you know how can I do that in Calc?

Thanks a lot!

In Calc you can use regular expressions, i.e. "A.*" instead of "A*"

LibreOffice 5.2 will also support the simple wildcards *, ? and ~, see the Release Notes.

Thanks! Great news for the next version!