value = '12 QZR 44A' def remove_numbers(name): return re.sub(r'w*dw*', '', name).strip() value.apply(remove_numbers)