I have this table
a
b
c d
now I wanna find the cell “c d”
tabfindincol("table1","c d","rc",0,0,"forward")
returns -1
It only works if I search for “c*d”, but as I get the “fixed” search string from another table, I need to squeeze in a substitute to replace " " with *
tabfindincol("table1",substitute(tab("curr",0,0)," ","*"),"rc",0,0,"forward")
Is there a more elegant approach? Or is it a bug?