How to truncate query results

8 views

Skip to first unread message

unread,

Mar 7, 2019, 3:55:06 PM3/7/19

to Google Visualization API

I have a very simple query that I need the results to return and to truncate the one of the values returned. Here is my query:

=QUERY(Sheet1!A:C,"select A, B where C contains '"&$B$1&"'", 0)

I need the value of Column B to return only 3 characters. I am not sure how to accomplish this.