Learn the NumPy trick for generating synthetic data that actually behaves like real data.
Excel has native regex support, and it works exactly how you'd expect.