Removing double quote on null column

[lilvi3tboix1]

Hi,
I been trying to find a way to remove double quote on null column on my CSV file but can not find any example. Is there anyone out there that can help me? Any help is appreciated.. Thanks.

[NBVC]

You tried using Text To Columns and delimiting the Double-quote?

Then in the next window, you select the column in the preview window and select do not import column.

Is that what you mean?

[lilvi3tboix1]

You tried using Text To Columns and delimiting the Double-quote?

Then in the next window, you select the column in the preview window and select do not import column.

Is that what you mean?

No, I just wanted to remove where the row of the column is null. For example

Before
1,"John",""
2,"Rick","TX"

After
1,"John",
2,"Rick","TX"

Do you get what I am trying to do?

[NBVC]

Not sure I got it, but perhaps, try to do an Edit|Replace and Replace the "" with nothing (leave the Replace With field blank).

[lilvi3tboix1]

Is there a way I can write a marco that do it for me?

[NBVC]

try recording a macro.