Reading txt file from VBA for Matlab

I am working parallel with Excel and VBA in order to create txt files I wish to use for MATLAB. However, I experience some format issues I can't resolve.

For instance, the following VBA

Open "example.txt" For Output As #1
    For i = 1 To 5
     Print #1, Sheets("Example").Cells(i + 3, 3)
    Next i

Indeed prints numbers (reals) it is supposed to however MATLAB struggles with reading this example .txt file.

There are some characters VBA is printing. I don't know how to delete those within a VBA code or tell somehow Matlab how to read this file

Example.txt opened in matlab. Note the NaN read by MATLAB from a text file:

[VBBV]

It occurs when the file has special characters or space. Matlab converts them as NaN which means Not a Number if the file has numeric data and text.

[VBBV]

You can delete those if you want after importing to matlab workspace

Answer 1

[Rishik Ramena]

You can process the NaNs after importing them to MATLAB. This link might be helpful.