+ Reply to Thread
Results 1 to 3 of 3

Remove trailing commas and spaces without changing text color format

  1. 11-24-2020, 07:09 AM #1
    Kinjal Doshi
    Kinjal Doshi is offline
    Registered User
    Join Date
    01-11-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    38

    Remove trailing commas and spaces without changing text color format

    Hi,

    I have found below function which removes trailing comma and spaces but it removes my text formatting too.

    Please Login or Register  to view this content.
    Can some one please help!, as I have thousand's of rows where I have to remove trailing commas and spaces while keeping the text format as it is.

    Ex: Current Cell - Peter(In black font), 1st Rank(In red font),
    Current Code result - Peter(In black font), 1st Rank(In black font)
    Desired result - Peter(In black font), 1st Rank(In red font)

    I have attached a sample file too!..
    Attached Files Attached Files
    Last edited by Kinjal Doshi; 11-24-2020 at 08:15 AM.
    Reply With QuoteRegister To Reply
  2. 11-24-2020, 07:50 AM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Remove trailing commas and spaces without changing text color format

    1) Code tags are missing.
    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


    [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]


    2) Not possible by function in cell.
    Select the cell(s) and run the code
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 11-24-2020, 08:19 AM #3
    Kinjal Doshi
    Kinjal Doshi is offline
    Registered User
    Join Date
    01-11-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    38

    Re: Remove trailing commas and spaces without changing text color format

    Thank you so much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Remove numerous trailing commas from text string that contains commas
    By JenSven1 in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2016, 10:19 PM
  2. Remove numerous trailing commas from text string that contains commas
    By JenSven1 in forum The Water Cooler
    Replies: 1
    Last Post: 05-23-2016, 11:05 AM
  3. how do I remove empty spaces trailing a text string?
    By Need_Help in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. [SOLVED] how do I remove empty spaces trailing a text string?
    By Need_Help in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. how do I remove empty spaces trailing a text string?
    By Need_Help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 12:05 AM
  6. [SOLVED] how do I remove empty spaces trailing a text string?
    By Need_Help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] how do I remove empty spaces trailing a text string?
    By Need_Help in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2005, 08:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1