+ Reply to Thread
Results 1 to 3 of 3

Replace Line break with Comma without changing color format

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    38

    Replace Line break with Comma without changing color format

    Hi,

    I have found below code that will replace my line breaks with comma.. but this removes by font color too.
    I have rows with many numbers where instead of comma they are separated by line breaks... Can someone help to tweak below code as per my requirement?

    Please Login or Register  to view this content.
    Ex:
    12345 (Black Font) Line Break
    678932 (Red Font) Line Break
    98756 (Red Font)

    Above Code result
    12345 (Black Font), 678932 (Black Font), 98756 (Black Font)

    Desired Code result
    12345 (Black Font), 678932 (Red Font), 98756 (Red Font)

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    Re: Replace Line break with Comma without changing color format

    Try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-11-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    38

    Re: Replace Line break with Comma without changing color format

    Perfect.
    Thanks again!

+ 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. Replies: 4
    Last Post: 10-21-2020, 11:42 PM
  2. Remove break line and comma before saving as csv
    By cyttorak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2015, 11:05 AM
  3. VBA to replace special characters with line break
    By saranyabi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 03:11 PM
  4. Replace comma with new line characters
    By OahuBrew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-12-2013, 04:05 PM
  5. Excel 2008 : Replace with line break
    By eleonb in forum Excel General
    Replies: 5
    Last Post: 11-01-2012, 12:18 PM
  6. Find/Replace with Manual Line Break
    By rkohlman in forum Excel General
    Replies: 1
    Last Post: 12-19-2006, 02:25 PM
  7. Replies: 2
    Last Post: 03-21-2006, 08:30 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1