Ask Your Question
0

Using wildcards in formulas [closed]

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

Tales Tomaz gravatar image

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

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
1

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

Comments

Thanks! Great news for the next version!

Tales Tomaz gravatar imageTales Tomaz ( 2016-06-10 21:08:04 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 4,034 times

Last updated: Jun 10 '16