New Find and Replace Roadblock

[kevs]

I have an important project I need to do for a client and I am up against a
brick wall, can someone help?

I doing a find a replace and every time I do this I get "formula too long"

I'm just finding one word of text. Not formula.

Why am I getting this?

Any experts on this?


In find:
Do put worksheet?

Do I Search by rows or columns? Have no idea why asking this.


And most important what Look in? I don't see option for text. I get this
"formula too long" even if formula is NOT selected.

Totally confused.

Same question for the replace.

Appreciate the help.

Kevs



OS 10.4.7
Office 2004

 

[JE McGimpsey]

Totally confused.

1) what word are you looking for? Does it occur in your formulae? What
are you trying to replace it with?

2) If you're not trying to replace the word in formulae, try selecting
only text cells (Edit/Goto/Special, select Constants, and uncheck all
but the Text checkbox.

3) If you're trying to replace in formulae, give an example of a formula
that has the target in it.

 

[kevs]

1) what word are you looking for? Does it occur in your formulae? What
are you trying to replace it with?

2) If you're not trying to replace the word in formulae, try selecting
only text cells (Edit/Goto/Special, select Constants, and uncheck all
but the Text checkbox.

3) If you're trying to replace in formulae, give an example of a formula
that has the target in it.

Ok , thanks JE.
Ok did what you said, I selected the columns with all the text cells,

then:
(Edit/Goto/Special, select Constants, and uncheck all

but the Text checkbox.

Did find for word and replace with nothing and got same message:

Formula is too long!!!!





OS 10.4.7
Office 2004

 

[JE McGimpsey]

Did find for word and replace with nothing and got same message:

Formula is too long!!!!

Then all I can suggest is that you answer the questions I posted...

 

[JE McGimpsey]

Yes, Bob, that is the problem. There is an artifact for ancient versions of
Excel that prevents Replace from generating a result greater than 1024
characters. Actually, I( just tested it, and the limit is somewhat less than
this, about 950 characters or so.

So, I guess kevs is out of luck, unless he can change the cell content. No
matter what the actual length of the cell's text, only the first 2048
characters will be displayed.

He can use a helper column:

B1: =SUBSTITUTE(A1,"word","substitute word")

Copy B1 down to B1000. Copy column B, Select column A, choose Edit/Paste
Special, selecting the Values radio button.

 

[kevs]

He can use a helper column:

B1: =SUBSTITUTE(A1,"word","substitute word")

Copy B1 down to B1000. Copy column B, Select column A, choose Edit/Paste
Special, selecting the Values radio button.

Ok guys thanks:
Here is what we are talking about;

http://img182.imageshack.us/img182/7171/picture2rz4.png


As you can see the character counts are at 1400 and I need to trim to 854. I
have Office 2004 BTW.

The helper column was a bit over my head.

In short, I made a new worksheet, column of 150 words (each in own row/cell)
called "bad keywords" and would like to do a find and replace on the column
I just posted and replace those bad keywords with nothing. Get them out of
the document.

Thanks! Again.

Kevs


OS 10.4.7
Office 2004

 

[jpdphd]

Ok guys thanks:
Here is what we are talking about;

http://img182.imageshack.us/img182/7171/picture2rz4.png

As you can see the character counts are at 1400 and I need to trim to 854. I
have Office 2004 BTW.

The helper column was a bit over my head.

In short, I made a new worksheet, column of 150 words (each in own row/cell)
called "bad keywords" and would like to do a find and replace on the column
I just posted and replace those bad keywords with nothing. Get them out of
the document.

Thanks! Again.

Kevs

OS 10.4.7
Office 2004

Here is a tedious, but effective (I think) approach.
http://homepage.mac.com/jdilger/Excel/keywords.png

have a fun weekend!

jpdphd

 

[kevs]

Here is a tedious, but effective (I think) approach.
http://homepage.mac.com/jdilger/Excel/keywords.png

have a fun weekend!

jpdphd

Thanks J:
I'm not into anything tedious. If if can't be easy like I do in Word, I'm
going to bag it.

If I can't tell Excel, look at these 100 words in this columns and delete
them from all these cells, then I cant do it. I'm too much of a excel
novice.





OS 10.4.7
Office 2004

 

[jpdphd]

On 5/25/07 1:16 PM, in article
(e-mail address removed), "JE McGimpsey"





Thanks J:
I'm not into anything tedious. If if can't be easy like I do in Word, I'm
going to bag it.

If I can't tell Excel, look at these 100 words in this columns and delete
them from all these cells, then I cant do it. I'm too much of a excel
novice.

OS 10.4.7
Office 2004

You have to admit that your task is not trivial. It wouldn't be
particularly easy in Word. You'd have to do Find/Replace 100x and type
each target in separately. (Which you can also do in Excel if you are
so inclined).
jpdphd

 

[kevs]

You have to admit that your task is not trivial. It wouldn't be
particularly easy in Word. You'd have to do Find/Replace 100x and type
each target in separately. (Which you can also do in Excel if you are
so inclined).
jpdphd

Thanks J! Yeah you are right I'm going to outsource this nasty job to a
professional.




OS 10.4.7
Office 2004