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

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).

Given formula is in row 80, and text string is in A80.

Enable wildcards in formulas, the result is`aaaaaaaarchg`

. EDIT: without`?`

.Enable regular expressions in formulas, the result is`aaaaaaaarchg`

.Enable wildcards in or regular expressions in formulas, the result is`aaaaaaaarchg?`

.I get no 1 nor 0 result.

EDIT: I am restarting LibreOffice, because I am getting different results now.