Remove Multiple line breaks and keep one

[Sufiyan97]

I have data like below, how to remove multiple line breaks and just keep one line break.

Book9
	A	B	C
1	Mailing Address	Mailing Address - Expected
2	ROBERT WIMER 115 CORRY AVENUE LANCASTER, PA 17601	ROBERT WIMER 115 CORRY AVENUE LANCASTER, PA 17601
3	TIMOTHY GAY 1164 OAKMONT DRIVE LANCASTER, PA 17601	TIMOTHY GAY 1164 OAKMONT DRIVE LANCASTER, PA 17601
4	Amy Grubb 117 Doreen Drive Hummelstown, PA 17036	Amy Grubb 117 Doreen Drive Hummelstown, PA 17036
5	Steven Grubb 117 Doreen Drive Hummelstown, PA 17036	Steven Grubb 117 Doreen Drive Hummelstown, PA 17036
6
Sheet1

 

[Fluff]

How about

=TEXTJOIN(CHAR(10),,TRIM(TEXTSPLIT(A2,CHAR(10),,1)))

 

[Sufiyan97]

Perfect Fulff.

Thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback.