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

Select Column-B press Ctrl+H to get the Find & Replace.

Place the cursor in Find what and hold the Alt Key and type 010
Click on Replace With and press space bar once.
Click Replace all

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!

Try CHAR(10) instead of CHAR(13)


Regards, TMS

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

One is CR, Carriage Return, the other is LF, Line Feed. Carriage Return takes you back to the beginning of the line, Line Feed goes to the next line.


Regards, TMS




If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.