I am working on a large worksheet (52,000 rows) and I need to distinguish
between differing cases of the same abbreviation. (For example, Abc should be
read separately from ABC). As Excel reads them as the same (a good default),
I have copied the contents of column AH (contains Abc and ABC formats) to
column AT. (I copied by setting the value of AT2 as '=AH2' etc.

I then try to 'Find' Abc and 'Replace' with A2c with the Match Case box
checked. But I get 'Excel cannot find anything to replace.

Trying to troubleshoot this problem, I created a 'play' column (AU). But
when I copied a few cells from AT to AU (using Cut and Paste), the contents
of the AU cells are not those of AT, but of AI! In other words, Excel is
responding to the right column shift (from AT to AU), and applying it to the
original source (AH) and returning one column right of it (AI).

Is this behavior standard or do I have a switch set wrong? I know that I can
do a Paste Special (Values only) to correct Column AU, but why is
Find/Replace not seeing the contents that I see (the Function box for AT2
shows '=AH2)?

Thanks as always.

Mike

Michael,

When doing your find click the 'Option' button and check 'Match Case'

Mike

"MichaelRobert" wrote:

I am working on a large worksheet (52,000 rows) and I need to distinguish
between differing cases of the same abbreviation. (For example, Abc should be
read separately from ABC). As Excel reads them as the same (a good default),
I have copied the contents of column AH (contains Abc and ABC formats) to
column AT. (I copied by setting the value of AT2 as '=AH2' etc.

I then try to 'Find' Abc and 'Replace' with A2c with the Match Case box
checked. But I get 'Excel cannot find anything to replace.

Trying to troubleshoot this problem, I created a 'play' column (AU). But
when I copied a few cells from AT to AU (using Cut and Paste), the contents
of the AU cells are not those of AT, but of AI! In other words, Excel is
responding to the right column shift (from AT to AU), and applying it to the
original source (AH) and returning one column right of it (AI).

Is this behavior standard or do I have a switch set wrong? I know that I can
do a Paste Special (Values only) to correct Column AU, but why is
Find/Replace not seeing the contents that I see (the Function box for AT2
shows '=AH2)?

Thanks as always.

Mike

MichaelRobert wrote:
I am working on a large worksheet (52,000 rows) and I need to distinguish
between differing cases of the same abbreviation. (For example, Abc should be
read separately from ABC). As Excel reads them as the same (a good default),
I have copied the contents of column AH (contains Abc and ABC formats) to
column AT. (I copied by setting the value of AT2 as '=AH2' etc.

I then try to 'Find' Abc and 'Replace' with A2c with the Match Case box
checked. But I get 'Excel cannot find anything to replace.

Trying to troubleshoot this problem, I created a 'play' column (AU). But
when I copied a few cells from AT to AU (using Cut and Paste), the contents
of the AU cells are not those of AT, but of AI! In other words, Excel is
responding to the right column shift (from AT to AU), and applying it to the
original source (AH) and returning one column right of it (AI).

Is this behavior standard or do I have a switch set wrong? I know that I can
do a Paste Special (Values only) to correct Column AU, but why is
Find/Replace not seeing the contents that I see (the Function box for AT2
shows '=AH2)?

Thanks as always.

Mike


You need to copy the values from column AH into column AT. Find is looking at
the formula ("=AH2"), not the result of the formula("ABC").