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 :

A	B	C
a b c	abc
d e f	def

<tbody>
</tbody>

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