Ask Your Question

Using wildcards in formulas

asked 2016-06-10 20:04:35 +0200

Tales Tomaz gravatar image

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-06-10 21:02:25 +0200

erAck gravatar image

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.

edit flag offensive delete link more


Thanks! Great news for the next version!

Tales Tomaz gravatar imageTales Tomaz ( 2016-06-10 21:08:04 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-10 20:04:35 +0200

Seen: 2,591 times

Last updated: Jun 10 '16