I would like a formula that removes the ending of each of the text so it's consistent 
https://docs.google.com/spreadsheets/d/1ysjz4B6Eh4eE5y_cYg76_CilkUena6iQDZtIIMhXSOs/edit?usp=sharing
-
The sample spreadsheet gives "Access denied." See The correct way to publicly share a Google test sheet.– doubleunarySep 14, 2022 at 9:56
Add a comment
|
1 Answer
Use regexextract(), like this:
=arrayformula( iferror( regexextract(A2:A, "(.+)-"), A2:A ) )
answered Sep 14, 2022 at 9:55
