Insert a Line-Feed Between Every 3rd Character Using Excel’s Power Query

This video responds to a question: how can you add a line-feed between every 30th character.

This was a bit intimidating as I wondered WHY would someone’s data be in such a condition? But I thought of an example where area codes might be all smashed together, with no other way to split them apart except for knowledge that they’re always 3 digits long.

In this video, you see Power Query (Get & Transform), split by number of characters, insert line-feed.


My book: Guerrilla Data Analysis 2nd Edition
Thumbnail image taken by Marina Green Photography

My old blog: