One of those little things that sometimes needs to be done when working with many lines of information is the removal of an odd character here and there.
I was in just that position today. I had about 2,000 lines of information, and about 600 of them ended with a comma, and the rest didn’t.
I needed them all to be without the comma. Unfortunately, there were a number of other commas in the lines so I couldn’t just do a simple find and replace.
So, this is the excel code that I used:
This removed the last character from the data in cell A1.
I used the filter options to only select cells that ended with the comma, and then applied that code to those lines.
I then copied the entire column and pasted as text, where I needed the corrected information.
Other similar codes:
To remove the first few characters
This will remove the first 3 characters of the cell content.
667.1 - 699,646