2

I made a simple query function as this: =QUERY(range,"select *",1), in my Google Spreadsheet, but the results dose not show any letters, it shows only fields that contains numbers.

Rubén
  • 34,714
  • 9
  • 70
  • 166
user7339664
  • 21
  • 1

1 Answers1

3

Study this link

Syntax

QUERY(data, query, [headers])

data - The range of cells to perform the query on.

Each column of data can only hold boolean, numeric (including date/time types) or string values.

In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values.

Just format your range as a plain text using Format > Number > Plain text option, the below images show how to do it:

enter image description here

enter image description here

enter image description here

Community
  • 1
  • 1
krokodilko
  • 35,300
  • 7
  • 55
  • 79