I have a column of data.

Some end in 'N' some don't.

For the ones that end in 'N' I would like to remove the 'N'.

Find and replace wouldnt work as some of them have an 'N' at the start or in the middle.

How can I removed the last charcter if it is an 'N'?

Thanks.