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

/in /by

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.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
Thumbnail image taken by Marina Green Photography

HOME

My old blog: http://datascopic.net/blog-2-2