Ask Your Question

Searching for a certain number not digit in Calc [closed]

asked 2014-04-02 09:06:50 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Please, could someone tell me if there is a way to find (select) cells on the basis: Find cells in Calc that contain, let's say, number ''1'', but not the numbers ''11'', ''13'', ''211'' etc.. Thank you very much!

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 2016-02-20 18:42:13.620404

2 Answers

Sort by » oldest newest most voted

answered 2014-04-02 22:59:19 +0200

m.a.riosv gravatar image

updated 2014-04-02 23:00:52 +0200

Hi Anne, if you want to find out the cells with only a 1, you can use regular expressions.
Search for: ^1$

Look in the help for regular expressions to learn how to use it.

image description

edit flag offensive delete link more


Muchas gracias, Mario. I like to use Libre Office, it's GNU and beautiful software.

Anne Zinn gravatar imageAnne Zinn ( 2014-04-04 01:13:10 +0200 )edit

answered 2014-04-02 09:55:52 +0200

mahfiaz gravatar image

The function you are looking for is =MATCH(1; A1:A100; 0)

edit flag offensive delete link more


Thanks mahfiaz; For this task I must use the tool ''Find & replace''? I'm a newbie, sorry

Anne Zinn gravatar imageAnne Zinn ( 2014-04-02 10:47:52 +0200 )edit

No, you paste it to a cell and it shows you on which row the "1" is. It assumes the data is at A1:A100.

mahfiaz gravatar imagemahfiaz ( 2014-04-02 13:17:33 +0200 )edit

Question Tools

1 follower


Asked: 2014-04-02 09:06:50 +0200

Seen: 189 times

Last updated: Apr 02 '14