So i have this column of numbers and i wish to extract only the numbers before the "HE" text for example, this is what i need, and i don’t really know how to achieve this.
Maybe there is a way to use a formula or command to do this, i’ve been trying to use power tools add-on but to no avail i did not get it.
Maybe for clarification in each cell there are 2 lines, using alt+enter.
>Solution :
REGEXEXTRACT() is suitable in this case.
=REGEXEXTRACT(A1,"(.+) HE")
Few good tips here about REGEXEXTRACT().
For array approach use below formula-
=ArrayFormula(IF(A1:A="","",REGEXEXTRACT(A1:A,"(.+) HE")))
