Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Search for multiple characters in Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I've tried displaying the numbers in the Find field like this: 1 2 3 4 | 1,2,3,4 | 1, 2, 3, 4 | 1;2;3;4 | 1:4, but Find & Replace doesn't recognise them as separate numbers...

As always, cheers.

Search for multiple characters in Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I've tried displaying the numbers in the Find field like this: 1 2 3 4 | 1,2,3,4 | 1, 2, 3, 4 | 1;2;3;4 | 1:4, but Find & Replace doesn't recognise them as separate numbers...

As always, cheers.

Search for multiple characters at once in Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I've tried displaying the numbers in the Find field like this: 1 2 3 4 | 1,2,3,4 | 1, 2, 3, 4 | 1;2;3;4 | 1:4, but Find & Replace doesn't recognise them as separate numbers...

As always, cheers.

Search for multiple characters at once in using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I've tried displaying the numbers in the Find field like this: 1 2 3 4 | 1,2,3,4 | 4/1,2,3,4/ 1, 2, 3, 4 | 1;2;3;4 | 1:4, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers...

As always, cheers.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying the multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers... numbers, instead generating a "no results found" response.

As always, cheers.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY: 1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in the cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted i.e. cells containing 1A or 212. 2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in the cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted i.e. cells containing 1A or 212. .

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in the cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted i.e. cells containing 1A or 212.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in the each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted i.e. cells containing 1A or 212.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted i.e. e.g. cells containing 1A or 212.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted e.g. cells containing 1A or 212.

etc. 2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted e.g. cells containing 1A or , 212 etc. etc.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted e.g. cells containing 1A, 212A1, 28 etc.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted e.g. cells containing A1, 28 etc.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted.highlighted by the search.

Search for multiple characters at once using Find & Replace?

Hi all, I'm using Find & Replace at the moment to locate/select certain cells in a Calc document so that I can apply a Cell Style to them all at once. However it would be helpful if I could search for a few numbers at once, rather than each one individually; how do I do this? I can't find anything on this in the Startup Guide...

I've tried displaying multiple numbers in the Find field like this: 1 2 3 4/1,2,3,4/ 1, 2, 3, 4/1;2;3;4/ 1:4 etc. but Find & Replace doesn't recognise them as separate numbers, instead generating a "no results found" response.

As always, cheers.

IN SUMMARY:

1) Follow Opaques' answer below to find cells that contain the specified characters anywhere in each cell e.g. if the characters specified in your search are 1 & 2, any cells containing these characters will be highlighted e.g. cells containing characters A1, 28 etc.

2) Follow his/her subsequent comment to find cells that contain the exact characters specified e.g.if the characters specified in your search are 1 & 2, only cells containing exactly 1 or 2, and nothing else, will be highlighted by the search.