Filtering a list?

Hi, I have a list of abbreviation I need to filter on each week. My list is below. I need to filter out all the abbreviation that start with X but XLO and XFT. Is that possible? I was wondering if I could pull XLO and XFT into another sheet then join them back to the main sheet without any abbreviation that start with an X.
My list
CAT
DFT
FTC
FTX
XTI
XTE
XLO
XFT
XTC
XRT

Thank you
Kim

The regex:

^[^X]|XLO|XFT

Will match XML, XFT or anything not beginning with X.

1 Like