CODEWITHSUNDEEP
sqlgoogle-sheetsgoogle-query-language
user7339664
user7339664

Reputation: 21

Query in Google Spreadsheet

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.

Upvotes: 2

Views: 903

Answers (1)

krokodilko
krokodilko

Reputation: 36097

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

Upvotes: 3

Related Questions