apostrophes

"Dave Peterson" wrote in message
...
That was long way to go, but we got there vbg!

If life was meant to be easy God wouldn't have sent dumb newbies ;=)

You don't need the tilde for those non-leading apostrophes.

Saruman wrote:

Just happened across this post.

If you type a tilde character, (on the hash key next to the enter Key on my
keyboard), in a find and replace box with an apostrophe following it, you
can then remove a non leading apostrophe character.

Like this : Find What: ~'
Replace With:
--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Symantec Antivirus 10
---------------------------------------------------------------------------
"teepee" wrote in message
...

I have a formula with an apostrophe, but it's not a leading apostrophe.

='results.csv!$B1

I wrote it this way for reasons I won't bore you with, but there is a good
reason. The idea is that a particular moment I can take out the apostrophe
using find/replace and thus activate the formula.

I know removing the apostrophe by using find/replace doesn't work on
leading
apostrophes, but it does work on non-leading apostrophes in some
circumstances. Does anyone know what those criteria are? On some
spreadsheets it works, on others it doesn't.




--

Dave Peterson