Re: Search only values, then replace
- From: Pete_UK <pashurst@xxxxxxxxxxx>
- Date: Wed, 6 May 2009 16:43:06 -0700 (PDT)
You're welcome, Paul - thanks for feeding back.
Pete
On May 6, 9:03 pm, paul.domas...@xxxxxxxxx wrote:
That's an interesting function (Go To Special). The Text checkbox is
subordinate to the Formulas checkbox, though, so I didn't touch that.
The Constants checkbox did what I wanted. However, I note that a
numerical cell containing the value 3 (or =3) is not considered a
constant. It doesn't affect my search in this specific circumstance,
though.
Thanks!
On May 6, 12:39 pm, Pete_UK <pashu...@xxxxxxxxxxx> wrote:
Press F5 (GoTo), then click on Special, select Constants and Text
(i.e. unselect Numbers, Logicals and Errors). Click OK, and this will
then highlight those cells with values that are text. Then do CTRL-H
(Find/Replace) and enter your search string and replace string and
click Replace All - it will only affect the highlighted cells.
Hope this helps.
Pete
On May 6, 5:16 pm, paul.domas...@xxxxxxxxx wrote:
In Excel 2003, without using VB[A], is there a way go to all cells
whose *value* contains the search string, then replace that string
inside the cell with a replacement string if the cell doesn't contain
a formula? If I search formulas, there are too many unwanted hits.- Hide quoted text -
- Show quoted text -
.
- References:
- Search only values, then replace
- From: paul . domaskis
- Re: Search only values, then replace
- From: Pete_UK
- Re: Search only values, then replace
- From: paul . domaskis
- Search only values, then replace
- Prev by Date: Can individual sheets be password protected within a single workbo
- Next by Date: Re: Can individual sheets be password protected within a single workbo
- Previous by thread: Re: Search only values, then replace
- Next by thread: Complicated conditional formatting
- Index(es):
Relevant Pages
|
