[HELP] Excel Ungerade/Gerade filtern

Code:

$ cat serverlist.txt 
vilogngp1
vilogngp2
vilogngp3
vilogngp4
mongelvinq2
mongelvinq4
mongelvinq5
blablub101
blablub102
servername1
servername2
serverp1nameblub
serverp2nameblub

Code:

$ cat serverlist.py 
#!/usr/bin/python3
import re
NUM = re.compile(r'\d+')
with  open("serverlist.txt") as s:
    for line in s:
        line = line.strip()
        num = int(NUM.search(line).group(0))
        if (num % 2 == 0):
            print("EVEN", num, line)
        else:
            print("ODD ", num, line)

Code:

$ ./serverlist.py 
ODD  1 vilogngp1
EVEN 2 vilogngp2
ODD  3 vilogngp3
EVEN 4 vilogngp4
EVEN 2 mongelvinq2
EVEN 4 mongelvinq4
ODD  5 mongelvinq5
ODD  101 blablub101
EVEN 102 blablub102
ODD  1 servername1
EVEN 2 servername2
ODD  1 serverp1nameblub
EVEN 2 serverp2nameblub

Code:

$ grep -E '[13579](\b|[^0-9])' serverlist.txt
vilogngp1
vilogngp3
mongelvinq5
blablub101
servername1
serverp1nameblub

Zitat aus einem Post von COLOSSUS

In Excel kann ich dir nicht helfen, aber ich wuerde das (ohne Error-Handling) in etwa so machen: