How to remove next empty line in Cell

[ravi2628]

hi everyone,

in excel i have issue related to Cell

Cloumn 1[Input]	Column 2[Output]
Test1	Test1
Test2	Test2(With out Empty Line)
Test3	Test3

where as in Cell test2 Column1 having Empty Line.

need to remove Empty Line using Formula.

Thanks & Regards,
Ravi

 

[tyija1995]

What exactly do you mean by empty line?? That you have:
Test1

Test3

Like that? And then you want
Test1
Test3

?

 

[ravi2628]

What exactly do you mean by empty line?? That you have:
Test1

Test3

Like that? And then you want
Test1
Test3

?

after Test2 there is a new line without values

 

[ravi2628]

after Test2 there is a new line without values

EMAIL SAMPLE.xlsx
	A	B
11	Test1	Test1
12	Test2	Test2
13	Test3	Test3
Sheet1

Cell Formulas
Range	Formula
B11:B13	B11	=CLEAN(A11)