Find and Replace Conundrum - Giving up

[kevs]

I've had some threads here on my inability to do find and replace in Excel.
I'm pretty much tossing this. But just curious:
After how many years on this software, the engineers cant do something
simple like ask Excel to find the word Apple in column B -- without have to
resort to crazy complicated formulas? Ie, can't just highlight a column and
then do a find for Apple all the cells in the column?



Kevs







OS 10.4.7
Office 2004

 

[Harvey Waxman]

After how many years on this software, the engineers cant do something
simple like ask Excel to find the word Apple in column B -- without have to
resort to crazy complicated formulas? Ie, can't just highlight a column and
then do a find for Apple all the cells in the column?

I must have missed something but Find/Replce works just fine in Excel OSX and
Panther. I also copied a column into Tex-Edit Plus, made the change and pasted
it back into Excel. Fifteen seconds tops.

Must be more to this story.

 

[gimme_this_gimme_that]

Are you using VBA ? What about Application.Match ?

 

[kevs]

I must have missed something but Find/Replce works just fine in Excel OSX and
Panther. I also copied a column into Tex-Edit Plus, made the change and
pasted
it back into Excel. Fifteen seconds tops.

Must be more to this story.

Harvey:
There is more to story, you were not Here!
Yes that was very easy, better convoluted formulas I was getting.

Now here is the million dollar next question:
In word, can I tell word to find multiple words and replace the all with
nothing, ie delete them all. That's the key. I don't want to have to run a
find and replace 70 different time. Thanks!





OS 10.4.7
Office 2004

 

[PhilD]

After how many years on this software, the engineers cant do something
simple like ...

Just because the designers cannot read your mind and provide a
function that does exactly what you, and only you, want very
occasionally does not mean it is no good. The designers have instead
provided a host of other functions that, together, can do whatever
ANYONE wants. Other people have told you which functions to use. You
just need to think about them.

I get the impression that this last point is the nub of the problem.

PhilD

 

[Dr. Harvey Waxman]

In word, can I tell word to find multiple words and replace the all with
nothing, ie delete them all. That's the key. I don't want to have to run a
find and replace 70 different time. Thanks!

There is a 'replace all' option when you select replace. That should do it
easily. I don't use Word very much but I found out that you need to paste the
column as unformatted text (paste-special), make the changes, then copy/paste
back.

 

[Bob Greenblatt]

Harvey:
There is more to story, you were not Here!
Yes that was very easy, better convoluted formulas I was getting.

Now here is the million dollar next question:
In word, can I tell word to find multiple words and replace the all with
nothing, ie delete them all. That's the key. I don't want to have to run a
find and replace 70 different time. Thanks!





OS 10.4.7
Office 2004

Kevs,

Looking at your sample file which contains only text, indicates to me that
what ever it is you were trying to do, would probably be better in WORD> it
looks to me like you are expecting Excel to be a word processor, which it is
not. Copy your text into WORD, do the find and replace that you need, and
either keep the results in WORD, or copy to back to Excel. We have explained
to you what is wrong, and that find and Replace will NOT work for your case.

 

[kevs]

Kevs,

Looking at your sample file which contains only text, indicates to me that
what ever it is you were trying to do, would probably be better in WORD> it
looks to me like you are expecting Excel to be a word processor, which it is
not. Copy your text into WORD, do the find and replace that you need, and
either keep the results in WORD, or copy to back to Excel. We have explained
to you what is wrong, and that find and Replace will NOT work for your case.

I did that Bob, thanks, what I'm asking now, is it possible to find and
replace multiple words at once? I put in 10 words to find with and without
commas did not work (would be nice if you could do this in Excel)



OS 10.4.7
Office 2004

 

[Bob Greenblatt]

I did that Bob, thanks, what I'm asking now, is it possible to find and
replace multiple words at once? I put in 10 words to find with and without
commas did not work (would be nice if you could do this in Excel)



OS 10.4.7
Office 2004

No, that is not possible. Find will only find a text string, but you can use
wild card characters.

 

[kevs]

No, that is not possible. Find will only find a text string, but you can use
wild card characters.

Thanks again Bob!

OS 10.4.7
Office 2004