Does some macro exist for creating this text effect?
It's a Kinetic Typography piece. Search for templates on VideoHive, there are also plugins for AE that allow for easier generation of KT setups. 

It's timeconsuming, search vimeo for some great samples: Kinetic Typography. 

One of my all time favorites still to this day - produced years ago:  https://vimeo.com/17419652    The guy who did this spent months on it. But he did it all himself, great work.