Error 2029 - Simply Want Strings

I have a text file that I want to process. I put the data into 3 columns and pull it into a worksheet with VBA. I'm coming across a field that happens to start with a dash. It's being interpreted as a formula (I guess) and is giving me type mismatches when I try to test it in any manner. I put the column data into an array and my code looks like this:

Please Login or Register  to view this content.

Worksheet_Array(Row, 2) had "- The Shed Fund" but the spreadsheet shows =- The Shed Fund.

It looks like Excel is thinking it's a formula. How do I get it to work with simple strings, not evaluating anything in my sheet as any kind of a formula, and eliminate these errors?

Originally Posted by js0873

It's being interpreted as a formula

Obviously as per Excel rules you must format the destination cells as Text before to fill them
or just add a single quote at the beginning of the string …

Originally Posted by AlphaFrog

Try this...

CStr(Worksheet_Array(Row, 2))

I think that does the trick. Thanks!