Code to determine place of apostrophe

[ChrisGreaves]

@chris
Did you donwload the file and open it ?

No, I read the one-line code you posted in line.
I have since downloaded the file and examined it.
I see that there is a one-line function inside the workbook.
Cheers, Chris

[snb]

You might also have noticed that the cells in column B contain a formula that uses the UDF 'F_snb' in Module1 creating results that correspond for 100% to the TS's goal.

[ChrisGreaves]

BTW. Try thinking in suggesting approaches instead of offering solutions. The TS should be able to learn.

Hi snb.
Over the pasty fifty years I have been doing just that - and more. The sad truth is that some people join a forum solely to ask someone else to do their work for them. And some people do not want to learn; they want a turnkey answer. Then there are those who appear to be incapable of follwing the path of a training course.

The trend nowadays seems to be that young people want to be spoon-fed, and have no interest at all in using their minds.

As an example, I develop interpreters of Turing machines, Robots, and single-instruction computers to help trainees understand the power of macros (in the original sense of the term), libraries, called procedures and so on.
Cheers, Chris