I have a column in Excel with sample items below:

REG.N
KRG.N
ASN.N
PSB.N
PKY.N
PPS.N
PEI.N
MAA.N
MAC.N

I'll need to remove ".N" from each, so I pick "Replace" command and
enter ".N" replaced with blank.

However, when I select "Replace All", it seems that it cannot find any
".N" because I got the message about "Microsoft Excel cannot find any
data to replace". What's wrong with it?