+ Reply to Thread
Results 1 to 9 of 9

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

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

    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
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

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

    Hi,

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

    Regards,
    Chandra
    Attached Files Attached Files

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,774

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

    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


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

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

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    substitute by itself doesnt complete the job

    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.

  5. #5
    Registered User
    Join Date
    10-16-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

    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

  6. #6
    Registered User
    Join Date
    10-16-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

    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!

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,712

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

    Try CHAR(10) instead of CHAR(13)


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  8. #8
    Registered User
    Join Date
    10-16-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    19

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

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

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    46,712

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to process a word document line by line looking for "tags"
    By jmac1947 in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2014, 04:39 AM
  2. Replies: 1
    Last Post: 03-18-2014, 06:57 PM
  3. Replies: 0
    Last Post: 01-29-2014, 08:10 PM
  4. Remove Certain Line Breaks in cell
    By hollyc2424 in forum Excel General
    Replies: 1
    Last Post: 05-18-2011, 01:47 PM
  5. select & format "single" axis line in charts
    By Guru Guy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2006, 11:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1