View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default How come it say "Microsoft Excel cannot find any data to replace"?

Did you selected the column before Find/Replace?

....
Per

"Curious" skrev i meddelelsen
...
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?