Why Apostrophes Don't Appear in Cell??

Hello,

My question is about reading an Apostrophe/Single Quote to a cell.

My program reads a text file a single character at a time. And many lines of the text I'm reading begin with a single quote.

Unlike double quotes and other characters, single quotes aren't showing up in cells when they are read in first. They show up only in the function box. This is a huge problem for my program.

The following code produces the correct results:

Please Login or Register  to view this content.

This correctly writes the letter A to the first cell.

However, the following code:

Please Login or Register  to view this content.

... Doesn't write the single quote to the cell when it's the first character in the cell. It only writes the single quote to the function box. This is a huge problem because when i try to append the next character to the value of the cell holding the single quote, the single quote is entirely omitted and it never appears in the result.

Is there a workaround for this? How can I write a single quote to a cell and have it appear there when the next character is appended to it?

Thanks for any and all help.

Not entirely sure why/what you're doing but you may find that you're better off adding Chr(39) twice over at the end of processing all other chrs... so once you've processed the string do a test of the left most char and if it's chr39 repeat it twice, eg:

Please Login or Register  to view this content.

If you're looking to strip certain chars in a string you may find regular expressions a better / faster alternative to your current method... not for the feint hearted mind -- I'm still getting an idea of the basics myself but you'll find NBVC etc have posted quite a few examples - for more info see: http://www.regular-expressions.info/

Not that I can think of - other than 0 of course if the entire string is numeric and the cell is not formatted to Text... that's not to say there aren't any ...

There is always a way. It just depends on how easy the solution is. This one is easy - use the ampersand character like this

=char(39) & " Apple"

leaving spaces inside the quotes where you need them