My question might seem easy, but I have tried several things but still nothing works….!
I have a column, lets say called "a", that contains several thousands of "words".
What I want to do is to choose only those rows, where the value of "a" STARTS WITH "AC01".
I have tried the filter-function, but the problem is that it returns all rows CONTAINING "AC01", which sometimes is inside the word, but I only want the word when it starts with "AC01"
Anybody have any idea?