I realize that this might be a long shot considering how limited Google sheets seems to be but let's see if there are any Google sheets gurus on EE. :)
I have a sheet that is importing selected cells from another sheet that is populated by a Google Form, using the following formula:
=IMPORTRANGE("https://docs.google.com/spreadsheets/xxxxx","Form Responses 1!A2:A200")
But this column contains more than one answer, separated by a comma. It may appear like this: "3, N/A" or "5, Live" or "3, 4, Self"
However, I only wish to display the text and not the number values. Is there a way to filter and display only the three possible text results?