I have a col in a sheet that has an extra char that I need to remove for 400 rows.
The char is a "N" and is at the end of every row in col A. There is also space in between of what I want to keep. There is not set number of spaces in between what I want to keep and the "N". There are different begining words within the 400 rows.
See the attached.