I am trying to truncate cells in a column from a specific character in a string

I have a macro coded to create a new sheet, copy from the first sheet, and paste in specific format to the newly created sheet2. My problem is I cannot get column C to truncate at the end of each cell's string; being "..D" or "...D*". Every cell in column C ends in either "D" or "D*" and I need this removed. Any assistance would be helpful.

Code I am currently working with is shown below. I would like to insert the needed code after

CopyPaste_Sheet2.Hide
ActiveWorkbook.Sheets(2).Activate

Please Login or Register  to view this content.

Thanks for looking at my frustrations.

J.

Hello goldbeje,

This version of your macro will remove the "D" and "D *" at the end of the cells on Sheet2.

Please Login or Register  to view this content.