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
if you do clean by itself it will not look as nice without space in certain spots
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Re: Remove the "line breaks" within the cell to retain values in a single line
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
Re: Remove the "line breaks" within the cell to retain values in a single line
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!
Re: Remove the "line breaks" within the cell to retain values in a single line
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.
Bookmarks