Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Similar solution, though I used Find and Replace instead of Join.
Another one finished! Normally I would have used the TRIM formula, but with version 11.5, the red/ green bar told me what was wrong, so that prompted me to try the Data Cleansing formula instead.
pretty much the same as the solution. Another one down
Several steps to get there - getting great practice with these tools!
This one reminds me of the data I get at work LOL
My solution is attached.
Struggled with this longer than I'd like to admit, but got there in the end.