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. Please assist. -- This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/4d8a681c-b1ff-49a0-b11e-cacf0b091a81%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
