Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATwo solutions:
1: using the new data cleansing tool (Thank you @Alteryx for this tool)
2: using the Reg ex tool. @Seanadams i managed to work around the part where words were getting smashed into each other at he end of each line by using a blank value in the replacement text box.