Share via

Excel Empty Cell

Anonymous
2022-04-14T18:05:35+00:00

Let's say I have a very picky person that when they look at the original .csv file in TextPad that the empty cells are noted as ,"", but when you edit the file and save it the empty cells are now ,,

Example of orginal file

,"9345420709","","","","SUBTOTAL",

After edit and save

,"9345420709",,,,"SUBTOTAL",

To me, it's read as an empty cell in both examples but this person insists that the empty cell should have "" in it. What can I do in Excel so it keeps the "" in the empty cell?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 891.6K Reputation points Independent Advisor
    2022-04-14T18:40:15+00:00

    Hi PGilmore22,

    I am Dave, I will help you with this.

    That person is not correct, in a plain text data files like a CSV vile an empty cell will always be denoted as ,, and never as ,"", and that will always be parsed as an empty cell by Excel or any other spreadsheet or Database application.

    There is no way to get Excel to use the 2 double quote notation for empty cells.

    Was this answer helpful?

    0 comments