# Revision history [back]

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)

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!

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!

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 containing 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!

Hello,

If you want a range of number 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!

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)

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!

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!

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]$ 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]$

in Find

Hello,

If you want a range of numbers digits 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]$ in Find 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) 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