| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come it say "Microsoft Excel cannot find any data to replace"?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| How do you Find and Replace the word "and" but not the and in "han | Excel Discussion (Misc queries) | |||
| How to replace "#N/A" w "0"when vlookup couldn't find the match? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
![Curious[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
