Depends on many things, but genrally speaking, it can increase fuel economy slightly. Getting rid of your cat is the first stage, but a free flowing exhaust creates less restriction. Just dont go huge on a 1.4, im guessing 2" system will be plenty big enough 2.25" at a push.
Maintaining your engine, keeping it serviced will also sometimes increase mpg on a old engine.
Dont expect miricles though, if you want to save fuel, just drive a bit lighter. A 1.4 should already have good mpg.