How to remove first and last linebreaks in excel?

[hawkinsshirley]

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?