Formula to make a sentence in one cell in one line, instead of many lines

[MFT]

Dear All,

May I request you to help me on a formula/shortcut for below:

I have one cell contains a huge sentence. But it is broken down to many lines within the cell. However my ERP will read only the first line of the cell. I wanted to remove the ENTER between the lines and make the sentence in one line in the same cell.

As my data is huge it is time consuming to do it manually.

Kindly help with any shortcut or formula

 

[James006]

Hi,
You can test

=SUBSTITUTE(E6,CHAR(10),"")

 

[MFT]

Hi,
You can test

=SUBSTITUTE(E6,CHAR(10),"")

Thanks a lot James. The formula is working amazingly.

 

[James006]

You are welcome