0

Is the Query function capable of taking the contents of a cell and returning everything before the first instance of - or :?

Here is a screenshot of what I mean: enter image description here

Obviously, this isn't my actual data, just an example of how the data is written.

  • thats not rly a job for QUERY... – user0 Mar 6 at 14:27
0

=ARRAYFORMULA(IFERROR(INDEX(TRIM(SPLIT(SPLIT(A:A, ":"), "-")), , 1)))

0

  • 1
    I do already have a function that does what I'm looking for without Query. However, the reason I was hoping to do it with query was so that it would be much less complicated, which this absolutely does. So you pretty much got to the point of my question either way. Nice! – Gnrl Kitty Mar 6 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.