i want to mix multiple paragraphs into one paragraph in a cell. the final output should be one article or paragraph in a cell

[geetethan]

hey sir i need your help i want to mix multiple paragraphs into one paragraph in a cell. the final output should be one article or paragraph in a cell. for example :


[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]a
b
c[/TD]
[TD]abc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d
e
f[/TD]
[TD]def[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i guess you understood the thing i want to remove all my carriage returns or enters in A column and final output is in B column and the enters or carriage returns count are different

Thank you if you helped me ...

 

[Ron Coderre]

With
A1: containing text including carriage returns.

This formula removes the carriage returns:

B1: =SUBSTITUTE(A1,CHAR(10),"")

Is that something you can work with?

 

[geetethan]

With
A1: containing text including carriage returns.

This formula removes the carriage returns:

B1: =SUBSTITUTE(A1,CHAR(10),"")

Is that something you can work with?

thank you so much you saved my life time....))) i am new to excel....once again thanks