Filtre the rows which begin with lettre Z

[efenem]

1-Z123
2-ASDF
3-ZSDF
4-Z342
I want to filtre the 2 and get the rest but i cant with this new update there is not many options or i can not find more settings can someone help?

[MartinDDDD]

@efenem

1-Z123
2-ASDF
3-ZSDF
4-Z342

So what is you desired Output?

1-Z123
3-ZSDF
4-Z342

So anything that after the - has a capital Z?

If the format in general is always the same - e.g. Number-Capital Letter then you can use a Regular Expression with the Row Filter:

[0-9]{1}[-]{1}[Z]{1}.*

[MartinDDDD]

In case your column has just Z123, ASDF etc in it it is easier:

You can set row filter to Match Wildcard and filter for Z*:

Maybe some general feedback as I noticed that you have started seeking help more regularly:

I find that your questions are sometimes not very clear. If I need help I always try to make it as easy as possible for the people I want to help so I really try to be clear, precise, make data accessible in an easy way etc… maybe some food for thought for you

[efenem]

Thank you @MartinDDDD my english not the best thats i think i can not explain myself clearly.

[MartinDDDD]

I don’t think your English is bad :-). But maybe in future you can add more detail to the problem you are facing and prepare a simple example in Excel. That sometimes helps much more than 1000 words

[ScottF]

Glad that this thread is already solved, but in the spirit of the followup discussion I offer this thread:

How to Best Ask For Help on the Forum

How to Best Ask for Help Before we go into this subject: first, and absolutely foremost: always search before posting your question. Your question may have already been posted and answered in the forum. Searching can help you save loads of time and effort! Ok, with that out of the way, let’s go: How can you write a post that is most likely to get the help you need? You might think that logically, a good title for your post would be “Help with an error”, right? Well… not exactly. Put yourself …

@efenem happy to have you here, and thanks @MartinDDDD for (yet another) solution checked off