First time here? Check out the FAQ!

1 | initial version |

Hello,

If you want a range of number to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

See the following simple example (after having pressed `Find All`

dialog `Search Results is shown and all matching cells are highlighted)

2 | No.2 Revision |

Hello,

If you want a range of number to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

See the following simple example (after having pressed `Find All`

dialog `Search Results is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

3 | No.3 Revision |

Hello,

If you want a range of number to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containg a A or an B*)

See the following simple example (after having pressed `Find All`

dialog `Search Results is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

4 | No.4 Revision |

Hello,

If you want a range of number to be found, use `[pattern]`

.

`[1-4]`

(don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containg a containing A or an B*)

`Find All`

dialog `Search Results is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

5 | No.5 Revision |

Hello,

If you want a range of ~~number ~~numbers to be found, use `[pattern]`

.

`[1-4]`

(don't forget to tick option `Regular expressions). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

`Find All`

dialog `Search Results is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

6 | No.6 Revision |

Hello,

If you want a range of numbers to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option ~~`Regular expressions). ~~`Regular expressions`

). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

`Find All`

dialog `Search Results is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

7 | No.7 Revision |

Hello,

If you want a range of numbers to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions`

). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

See the following simple example (after having pressed `Find All`

dialog ~~`Search Results ~~**Search Results** is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

8 | No.8 Revision |

Hello,

If you want a range of numbers to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions`

). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

See the following simple example (after having pressed `Find All`

dialog **Search Results** is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

**Update 1** for exact matching: Use regexp `^[1-4]$`

9 | No.9 Revision |

Hello,

If you want a range of numbers to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the numbers 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions`

). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

See the following simple example (after having pressed `Find All`

dialog **Search Results** is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

**Update 1** for exact matching: Use regexp `^[1-4]$`

10 | No.10 Revision |

Hello,

If you want a range of ~~numbers ~~digits to be found, use `[pattern]`

.

`[1-4]`

(don't forget to tick option `Regular expressions`

). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

See the following simple example (after having pressed `Find All`

dialog **Search Results** is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

**Update 1** for exact matching: Use regexp `^[1-4]$`

in **Find**

11 | No.11 Revision |

Hello,

If you want a range of digits to be found, use `[pattern]`

.

Example - you want to find all cells containing at least one out of the ~~numbers ~~digits 1 to 4 (i.e one of 1,2,3,4) use `[1-4]`

(don't forget to tick option `Regular expressions`

). For more details on regular expression see ICU Regexp, which is used in LibreOffice.

**Note:** In this case `[1-4]`

is also a short version of `[1,2,3,4]`

(Now it is easy to adapt to other question like *Show me all cells containing A or B*)

`Find All`

dialog **Search Results** is shown and all matching cells are highlighted)

Have a nice trip to the world of regular expressions!

**Update 1** for exact matching: Use regexp `^[1-4]$`

in **Find**

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.