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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come it say "Microsoft Excel cannot find any data to replace"?
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!* "Curious" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come it say "Microsoft Excel cannot find any data toreplace"?
On Jul 16, 1:59*pm, "Per Jessen" wrote:
Did you selected the column before Find/Replace? ... Per "Curious" skrev i ... 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?- Hide quoted text - - Show quoted text - I didn't select the column at the beginning. Since it didn't work, I selected the column. However, it didn't work anyway. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How come it say "Microsoft Excel cannot find any data toreplace"?
On Jul 16, 2:01*pm, Luke M wrote:
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!* "Curious" wrote: 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?- Hide quoted text - - Show quoted text - 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. |
Reply |
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) |