Challenge #16: Parsing Out the New-line Character

[Sumanshu_GI]

An Easy One!!!

[alex2017]

My solution is attached.

[GiuseppeC]

My solution attached!

Spoiler

RegEx rules!

[FeedMeData]

Here's my solution

[robert-headington]

A nice and simple challenge - great for a beginner like me to learn

[VarshaRaj09]

0.3 seconds using select, formula and text to column.

[TonyA]

Here's my solution. Nothing new to add.

[TonyA]

I just found another approach that doesn't use the cleansing tool and explicitly replaces the newline with a space.

Spoiler

[hanykowska]

I was very close to over-complicating this but it's fine now.

[JonathanAllenby]

Here's my solution to challenge 16!