Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

OpenOffice / LibreOfiice / Calc - When i am searching for partial text in a column, if text contains the character "?", no results are given!

OpenOffice / LibreOfiice / Calc - When i am searching for partial text in a column, if text contains the character "?", no results are given!

For Example: =IFERROR(INDEX($A$1:$A279;MATCH(IF(SEARCH($G$1;A80)=1;A80;"");$A$1:$A$200;0));"")

If $G$1 is "aaa" the search formula for text string "aaaaaaaarchg" will result 1 (positive)

HOWever if the text string is "aaaaaaaarchg?" will result 0 (negative).

(? can be anywhere inside the text string).