New answers tagged


You mentioned =REGEXEXTRACT(A2:A3, "19..") To me, it would seem as if this would check both cells for any date starting with "19" and extract that into the cell. As you found out it does not work that way. REGEXEXTRACT works per row. So you would need =REGEXEXTRACT(A3,"#(.*)") On top of that, you would have to use the above ...

Top 50 recent answers are included