How come it say "Microsoft Excel cannot find any data to replace"?

  • Thread starter Thread starter Curious
  • Start date Start date
C

Curious

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?
 
Click on the Find&Replace options button. Make sure the "Match entire cell
contents" options is unchecked. Depending on how your data is actually setup,
you may also need to adjust the "Look in" option to values, instead of
formulas.
 
Did you selected the column before Find/Replace?

...
Per

"Curious" <[email protected]> skrev i meddelelsen




- Show quoted text -
Click to expand...

I didn't select the column at the beginning. Since it didn't work, I
selected the column. However, it didn't work anyway.
 
Click on the Find&Replace options button. Make sure the "Match entire cell
contents" options is unchecked. Depending on how your data is actually setup,
you may also need to adjust the "Look in" option to values, instead of
formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*






- Show quoted text -
Click to expand...

Thanks Luke M! After I unchecked "Match entire cell contents" option,
it worked. I don't recall when I checked that option in the first
place.
 
Back
Top