Replace with single tick - formula too long....
 

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
"Forumula too long error".

You can't see the difference in this post because this is just plain
text, but essentially, Word's tick is more like a "back tick" 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 3" 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!

Replace with single tick - formula too long....
 

It might be easiest to do it with a macro:

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

I was successful in Doing Edit=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 Ogilvy


" wrote:

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
"Forumula too long error".

You can't see the difference in this post because this is just plain
text, but essentially, Word's tick is more like a "back tick" 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 3" 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!