Remove trailing commas and spaces without changing text color format

**Kinjal Doshi** · 11-24-2020, 07:09 AM

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!..

**jindon** · 11-24-2020, 07:50 AM

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.

**Kinjal Doshi** · 11-24-2020, 08:19 AM

Thank you so much!

Remove trailing commas and spaces without changing text color format

LinkBack

Thread Tools

Rate This Thread

Display

Remove trailing commas and spaces without changing text color format

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Remove numerous trailing commas from text string that contains commas

Remove numerous trailing commas from text string that contains commas

[SOLVED] how do I remove empty spaces trailing a text string?

[SOLVED] how do I remove empty spaces trailing a text string?

how do I remove empty spaces trailing a text string?

[SOLVED] how do I remove empty spaces trailing a text string?

how do I remove empty spaces trailing a text string?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions