Forum Discussion
Remove end comma
I have a report that I exported into Excel 2010. The report has a date field 08/31/2018. When the report comes over to excel, an end comma is placed after the date "08/31/2018,". This report can b...
As variant you may select cells with such dates, Ctrl+H and replace comma on nothing
SergeiBaklan, if I have multiple dates, is there an easy way of doing this? The report spans the whole month, so I will have multiple dates with the comma at the end. I might also have multiple lines with the same date. I suppose I just need to CTRL+H for each date that appears...
Karen, you may select cells from D123 to D152 (or so), after that press Ctrl+H and remove the comma
