Ask Your Question

Using wildcards in formulas [closed]

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

Tales Tomaz gravatar image

updated 2020-07-23 20:35:44 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-23 20:35:57.741002

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )edit

Question Tools

1 follower


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

Seen: 4,376 times

Last updated: Jun 10 '16