Apostrophe as an apostrophe to a cell?

[Jaymond Flurrie]

How can I write an apostrophe (') to a cell so that it is actually recognized as an apostrophe?

I mean, I have a string 0.2.1.|' in a cell that I split so that the left side (cell A1 or whatever) is 0.2.1. and the right side (cell B1 or whatever) is '. If I make this split and I write to cell C1 formula =B1="'", the result is false. How do I make it true?

The final reason why I need this is that my parser is looking for any given string, and ' has to be acceptable string (for example to mark a start of a string)

 

[Jaymond Flurrie]

I was able to solve it. It goes by using chr(39) in VBA.

 

[westconn1]

you can escape it ''