software

I'm trying to do a global search and replace in a spreadsheet and
replace a MS Word Tick with the generic text tick and I keep getting a
quot;Forumula too long errorquot;.

You can't see the difference in this post because this is just plain
text, but essentially, Word's tick is more like a quot;back tickquot; as
opposed to a 'straight up/down' tick as shown in this posting. When
trying to replace with the standard up/down tick I think it thinks I'm
trying to create a formula which I'm now...

Anyone have any ideas on how to fix this?

Example sentence....

Our 3quot; sitting bunny is the perfect bite size cookie cutter for Easter.
Don't forget to take a look at our edible Easter confetti and
sanding sugars.

The keyword is Don't.

Thanks!It might be easiest to do it with a macro:

Sub Replace()
Cells.Replace What:=Chr(146), _
Replacement:=quot;'quot;, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
End Sub

I was successful in Doing Edit=gt;Replace

then in the Replace what box I held down the right ALT key while i entered
0146 from the Numbers KEYPAD. In the replace with, I entered a single quote.

--
Regards,
Tom Ogilvyquot; wrote:

gt; I'm trying to do a global search and replace in a spreadsheet and
gt; replace a MS Word Tick with the generic text tick and I keep getting a
gt; quot;Forumula too long errorquot;.
gt;
gt; You can't see the difference in this post because this is just plain
gt; text, but essentially, Word's tick is more like a quot;back tickquot; as
gt; opposed to a 'straight up/down' tick as shown in this posting. When
gt; trying to replace with the standard up/down tick I think it thinks I'm
gt; trying to create a formula which I'm now...
gt;
gt; Anyone have any ideas on how to fix this?
gt;
gt; Example sentence....
gt;
gt; Our 3quot; sitting bunny is the perfect bite size cookie cutter for Easter.
gt; Don't forget to take a look at our edible Easter confetti and
gt; sanding sugars.
gt;
gt; The keyword is Don't.
gt;
gt; Thanks!
gt;
gt;