How to remove first and last linebreaks in excel?

Below are the input which is copy from excel column. There are some random number of linebreaks in first and last position.

"

Test 1
Test 2
Test 3
"

"
Test 1
Test 2
Test 3

"

"
Test 1
Test 2
Test 3
"

"

Test 1
Test 2
Test 3

"

I need output as below:

"Test 1
Test 2
Test 3"

"Test 1
Test 2
Test 3"

"Test 1
Test 2
Test 3"

"Test 1
Test 2
Test 3"

The above output removes all blanklines and linebreaks. Is it possible in excel or VBA?

please read the yellow banner at the top of this page on how to attach a file. Cannot manipulate data that you have typed into the thread. Need to see the file.

Okay, this is a brunt strength approach. There might be a better one utilizing FREQUENCY or some other function. My assumptions are
1. There's never more than three line breaks in a row
2. There are no double line breaks between text
3. The text might contain blanks.
Here's the formula for B2 copied down

Formula:

Please Login or Register  to view this content.