append to google spreadsheets query function -

i using query function in google sheets copy 1 column tab:

=query(tabname!$a:$y, "select j")

i modify imported column, (examples below), can't:

=query(tabname!$a:$y, "select j")+1 error: 'function add parameter 1 expects number values. 'estado civil?' text , cannot coerced number.'

=right(query(tabname!$a:$y, "select j"),2) error: 'formula parse error'

why not?

for

  =query(tabname!$a:$y, "select j")+1

to work, j must number, it?

for work,

  =right(query(tabname!$a:$y, "select j"),2)

j must string.

in case both works fine. if want whole column,you need enclose in arrayformula this.

 =arrayformula(right(query(tabname!$a:$y, "select j"),2))

ANy