Results 1 to 8 of 8

Removing multiple line breaks into single line break

Threaded View

  1. 12-01-2020, 11:21 PM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,649

    Re: Removing multiple line breaks into single line break

    Try in next cell, C2:

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,CHAR(10),"|"),CHAR(13),"|"),"||||","|"),"|||","|"),"||","|"),"|",CHAR(10))
    Drag down

    Copy/past special/ value: back to B2, or other cell D2
    Attached Files Attached Files
    Quang PT
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I find and Replace multiple line breaks with a single line break?
    By PatricMiller in forum Excel General
    Replies: 4
    Last Post: 10-21-2020, 11:42 PM
  2. Formulas and Line Breaks - inserting mid-string & removing excess breaks
    By MattDay2u in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-24-2017, 09:54 AM
  3. Combine 2 cells with line breaks in each of them and keep line break formatting?
    By stoneperfor in forum Excel General
    Replies: 7
    Last Post: 08-06-2014, 08:47 AM
  4. [SOLVED] Remove the "line breaks" within the cell to retain values in a single line
    By ahamedcader in forum Excel General
    Replies: 8
    Last Post: 07-14-2014, 03:07 AM
  5. Page break preview and moving page breaks, cursor does not line up with gray line.
    By KimberlyY in forum Excel General
    Replies: 0
    Last Post: 02-19-2014, 03:49 PM
  6. Removing Existing Page Breaks and Inserting a Page Break every third Total Line
    By Kalvas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2013, 05:12 AM
  7. Removing Line Breaks In A Cell
    By Ross220681 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-10-2009, 11:14 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1