Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #53: Parsing Report Formatted Data

TGreen
8 - Asteroid

Solved.

nSpire
10 - Fireball
Spoiler
053.png

RebekaMazuchova
8 - Asteroid

:)

Daniel_Homola
8 - Asteroid

Here!

JBevan89
8 - Asteroid

Good challenge.  I decided against using a macro, because I feel that hypothetically if the columns changed then I could just adjust the text to column tool. 

Dhrish
8 - Asteroid

Solution

Matthias_Albert
8 - Asteroid

A standard macro. Handles up to 50 columns and the user gets to select the delimiter character. :)

Spoiler
Matthias_Albert_0-1751545594374.png