Remove the "line breaks" within the cell to retain values in a single line

I have a sheet where the values in Column B has values displayed with "line breaks". I need to remove & replace these line breaks with just a 'space' so that the values are displayed in a single line.

Example: BEFORE
'You are receiving this e-mail because ASR action items have been assigned for:



SAR - SAR0000050D

PM - Harris, Nichole C





Thank You!!

SAR Governance Support Team

(Please do not reply to this email as it is an automatically generated message. For

AFTER:
'You are receiving this e-mail because ASR action items have been assigned for: SAR - SAR0000050D PM - Harris, Nichole C Thank You!! SAR Governance Support Team (Please do not reply to this email as it is an automatically generated message. For

Hi,

I guess you just need to uncheck the Wrap Text option under Format Cells. Please see the attached file.

Regards,
Chandra

Hi Chandra, thanks for looking into it
I have tried that earlier but this doesn't seem to solve the problem. when the cell is highlighted, you'll still find the line breaks in the 'entry' bar

I tried this, I am getting an error "Microsoft Excel cannot find any data to replace..."
can you please share the sheet if you have tried it. Thank you!

Thanks a lot, this does the job, can you please educate me what does CHAR(13) represents compared to CHAR(10)